Access Report Help

[peterzou99]

If i have a data base with 10 companies and for each compnay there are 10 products, i need to generate 100 report to cover all. Does anyone know if it is possible to build a kind of switchboard, where i can use a drop down menu for company and another down menu for product, then i just click the company and product i selected to generate the report i needed.
If you have any idea, please feel free to email me at peterzou33@yahoo.com
your help is greatly appreciated.

 

[Mile-O]

Use a Parameter Query - getting the parameters from a form wheeby the options are selected from two comboboxes - and base the report off that.

 

[peterzou99]

thanks, a little detail

Use a Parameter Query - getting the parameters from a form wheeby the options are selected from two comboboxes - and base the report off that.

thank you very much for your information.
could you give me detail or instructions how to perform it. i am a beginner on access.
Have a nice day.

 

[Mile-O]

Build your query as you would to select all the details you want.

In the relevant criteria fields put a parameter which will refer to the form to get the value as the criteria.

i.e.

[Forms]![MyForm]![MyCombobox]

 

[jdwhytie]

Create a query with your fields for company and product and then whatever other infor you need. In the criteriea for these two fields put in a reference to the field in your form, i.e. Forms!MyForm!ComboBoxName

With your form open, running the queary should return your results for that company and product, then you just have to make a report that is based on your query and make it open whenever you push a button or whatever you want to do.

-Jake