Best Way Handle a Date Range

[cc143most]

I have a very basic MasterTbl that is imported from Excel.&nbsp; Each line item is a task that was not completed on-time.&nbsp; The fields are: Employee, Customer, Date (This is a daily Long date with time that I have formatted to Short Date).&nbsp; I need to count this data different ways and have created several Crosstab Queries:<br>1) Number of shifts worked by Employee<br>2) Number of customers helped by employee and shift <br>3) Total number of customers helped<br>4) Total of overdues with breakdown by date (count of Date)<br><br>These all work great and give me exactly what I need.&nbsp; However, I need to be able to enter a date range and have the totals from each of the above queries reflect that date range so that I have one report that shows the employee, how many shifts were worked for the time period, how many customers were helped, and how many tasks were not completed on time (this comes from the date field).&nbsp; <br><br>Do I have to create separate queries, entering the date range for each, or is there an easier way?&nbsp; I feel like I am making this harder than it should be, but have completely confused myself.<br><br>Thank you for any help you can provide!

[pbaldy]

No need for separate queries; just add a criteria in your query. Most of use use forms to gather user input, in which case the criteria would look like:

Between Forms!FormName.FromTextboxName And Forms!FormName.ToTextboxName

Special note for crosstab queries:

Crosstab Query with a Parameter

[cc143most]

Paul,

Thank you for the reply. It worked great, although it took me quite a while to figure out how to use the form to run my queries. Data Pig Technologies' instructional videos helped tremendously for this. I am not very good at reading and applying the knowledge; I do much better being shown so their short videos are great for me.

Have a wonderful day!

[pbaldy]

Glad you got it working!

[cc143most]

How do I mark this as solved?

Thanks!

[pbaldy]

I did it for you; it's up at the top under "Thread Tools".