Report Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a report that asks for the data you want it to print. That is, I want the user to be asked from what date to what date do you want on this report. Any suggestions, links, etc., would be greatly appreciated.
 
rbkading said:
I am trying to make a report that asks for the data you want it to print. That is, I want the user to be asked from what date to what date do you want on this report. Any suggestions, links, etc., would be greatly appreciated.


Best way is to use a form with two rext boxes for the dates
and a button to print the report. The code behind the
button's Click event would use the OpenReport method's
WhereCondition argument to filter the report's data.

A quick and dirty way is to add parameter prompts to the
report's record source query. Just add the criteria:

BETWEEN [Enter Start Date] AND [Enter End Date]

under the date field.
 
Back
Top