How Do I Build This?

[lana_faith]

How do I build a form which will pull only certain work orders from my table [Work Orders], filter it through a query, [Payroll] which gives me only those work orders which match a certain repID#, for only certain Invoice Dates, and and then display a talley of the total number of times a certain product appears in the field [ProductSold] on the query [Payroll]?

 

[Melaz29]

Create a query and a form to run your query from....

Have date fields and a combo box (with the rep IDs) on the query form and use those for your criteria.

Then use a command button to execute from the query form.