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?