IMBOYCE
01-25-2002, 03:32 PM
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
adz2013
01-28-2002, 09:36 AM
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
DougS
01-30-2002, 07:09 AM
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
boycie
02-03-2002, 02:29 PM
Thanks very much for the replies - both are great.