generate report by form values

[arctushar]

Hi
I need help from u brother. I want as below

there will be form consisting two drop down menu 1. category 2. worker. and a button

Now I want that after clicking on the button it will generate a report which only meet the criteria both category and worker. Also there will be a sum of the quantities in footer and previous sub in header.

Is it possible? If possible the plz discuss here

 

[highandwild]

What you need to do is create a query that the report is based upon and
make reference to values on the form in the criteria row of the query.

Look at this page:

http://office.microsoft.com/en-us/access/HA011170771033.aspx
and this section
Creating a form to supply parameters to a query
Get the form correct first, then sort the query out and then point the report at the query.

 

[SOS]

Actually there is an easier way - you can have a generic report with the data you want but no criteria and then you can open the report by passing the criteria to it.

See this sample of Bob Larson's for a good way to do it.