help on date ranges in reports

[grayth]

Question I am trying to design a report that displays the commission values for a client and I want to have the ability to choose a begginning date and an end date and then when i run the report the appropriate info is displayed.

So far my report runs fine except i can't figure out how to add this functionality to it allowing the user to choose the date ranges and then the report running based on those values. any ideas how to set this up?

 

[Skippymouse]

If you add this phrase to the criteria of the date field in the query behind the report/form it will prompt for dates. Be sure to keep date format in mind (usually short date works best- mm/dd/yyyy). If you are not drawing from a query, simple create a query that matches your table and then proceed from there.


Between [Type the beginning date MM/DD/YY:] And [Type the ending date MM/DD/YY:]


Hope that helps!

 

[dkirk02]

Here's something else that's cool...if your client doesn't mind typing the date range in twice, you can actually put the following in your report header and display the same date range on the report itself. To do it, place a new text box on the report header, say, under the report name. Delete the label that goes with the box, and then place the following in for the control source of the text box.
="Cases From" & [Beginning Date] & " to " & [Ending Date]