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

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 (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.

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 (http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip) for a good way to do it.