Problem pulling data from a specific category

[plasma]

I'm trying to create a report that will only pull data from a specific category. For example, I have a Table, called "Category" and inside it has 3 items listed: "cpu", "mobo" and "ram". I also have a Table that contains more data specific to my categories, and also references those categories.

I would like to be able to create a report that will only show the data from the "cpu" category and not the "mobo" and "ram". I have done this in the past, but I cannot figure out how today, lol. Getting old stinks.

Hope it makes sense. thanks for any help..

 

[pbaldy]

If it will always have that restriction, you can base the report on a query that includes that as a criteria.

 

[plasma]

If it will always have that restriction, you can base the report on a query that includes that as a criteria.

that's what i was thinking, but I just can't remember how to do that..

 

[pbaldy]

Create a query that pulls the appropriate fields from the table. Put cpu in the criteria under the category field. Make that query the record source of the form.

 

[plasma]

Create a query that pulls the appropriate fields from the table. Put cpu in the criteria under the category field. Make that query the record source of the form.

great, thanks

 

[pbaldy]

No problem.