MS ACCESS DB help

Question

I have a c# program with a MS Access DB that holds various details about various things.

I have created a set of functions to build the sql requests / oledb requests for reading writing and counting e.t.c using RequestScalar, although now I have hit the limit of my knowledge of oledb and queries.

I have a table that contains a set of records each with a uniquie ID and other details including a category id. Each category ID can be used many times in this table for different records.

I have the category ID and I want to fetch all of the records that have this category ID.

Can anyone guide me in the right direction?

Thanks in advance
Adam