How do I create this report?

[S_DeLaire_2002]

I have an inventory database to keep track of our pc's at 2 different hospitals. I want to create a report so we can just click a command button to see all pc's in one hospital and have a seperate command button to show everything in the second hospital. I am pretty new at access. Thankz.

 

[David R]

You can specify criteria in the DoCmd.OpenReport line to only open certain records. Type 'DoCmd.OpenReport ,,,,,,,' and watch what you are prompted to enter for each comma. Most helpful stuff in there.

HTH,
David R