Reports for category of equipment

[shanewa]

I have a table with different types of equipment with fields such as asset tag, category, model, location, issued to and date. I have a seperate table for the categories. I am looking for the best way to create a report on the specific categories.

I have 14 caterories and I want to generate a report to tell me all the information on a particluar category. My goal is to search for equipment by category that might need to be upgraded based on age of equipment by just printing all records of a particlur category. Any suggestions to a newbie to access? Should I create a combo box on a form that displays the info in datasheet view and then print it??? Thanks

 

[jrbarnett]

Create a form with a drop down list based on the category table, then use the details in here to make it filter a report (which you must design separately):

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=3619

John