Displaying Specific Query Data in Textbox

[Kevin-anderson]

I have a query that displays emloyee name and hire date. I need to display these hire dates on a report; however, i want each text box on the report to count how many dates fall in a certain range.

So the query has all Employee hire dates and i want textbox 1 to count employees hired between date 1 and date 2.

Is this possible>?


Thanks kevin

 

[Mattster]

Yes that is very possible Kevin, I would do this such that your report references a form, with two feilds date1 (early date), and date2 (late date). Inside your query for this report reference these two dates >[date1] and <[date2]

Hope this works