query parameter on report

  • Thread starter Thread starter IMBOYCE
  • Start date Start date
I

IMBOYCE

Guest
hi,

I have a report based on a query in which one of the fields(date field) I ask the user to enter 2 dates. How do I then show the dates selected on the report. Thanks
 
if you are asking for a start date and a end date. On the report put a text box and in it put =[Enter Start Date]. Then put a second text box and put =[Enter End Date]. You must put the same wording in the text boxes that is in the peramiter in the query. Just put a = in front of it.

Hope this helps
 
You could use 1 text box only and type
=[Start Date] & "-" & [End Date]

This will put in the 2 dates with a - in between them
 
Thanks very much for the replies - both are great.
 

Users who are viewing this thread

Back
Top Bottom