showing a criteria input from a query in a report

[T-Dal]

Hey,
How do i go about conveying a critera input in a text box, for example when openeing a report the report is linked to a query to it will ask for 2 dates you want to view data within, how could i put a header in like = 'dates between [criteria input1] and [criteria input2]' on the report in a text box.

Thanks in advance

 

[Uncle Gizmo]

Instead of opening the query from a command button, open another form instead, and have two text boxes on this form to enter your dates. You can now referenced these text boxes as the criteria of the query, and also reference them to display the start date and end date on the report.

This question has been answered here many times before, the search may produce more information.

 

[T-Dal]

ok thanks gizmo, now i have one last problem relating to my report:



http://g.imageshack.us/thpix.php

now as you can see the expression =sum(hours) totals all sets of hours for all facilites used, how do i go about making it seperate so instead of a total of 13 it would be divided up for each facility - 5 hours and 8 hours?

Thanks!