First, I built a query that selects columns from a sales table and groups them by employee and month. Then, I built a report based upon this query that lists sales numbers per employee and month.

But, I would like to create a small form, where users enter their name and the month they want to look at and then the report gets created based upon the parameter selection.

I would like to extent the query I already have that groups my records based on employee and month, I just want the users to be able to specify which month and employee summary report they would like to look at.

But, I don't know anymore where to start. Does anyone know how I can easily extent my query code to include a parameter form?

Rahel

In the criteria in the query for the report, enter in the fields a reference to the form. Example;( in the Employee fields enter, forms![form Name]!employee. Then do the same with the month field.

I hope this makes sense.