Date from Query

[RandyMcI]

I have a report that is based on a query that contains a between statement on a date field.

How can I trap the Start date and End date that the user enters on the query and print the print the 2 dates on the report.

Thank you

Randy

 

[THWatson]

Randy
I assume you have parameters in your query that call for the user to enter the Between [start date] And [end date].

In your report header, put an unbound text box that would be something such as the following

=This report covers information between " & [start date] & "and " & [end date]

Hope that helps.

Tom

 

[KenReay]

Hi

How are you getting the user to enter the dates?, with [From Date] type criteria?

Usual way to do this is to use a form to request the dates, include a button to run the report

in the query use Forms!MyForm!FromDate to syntax in the query, you can also include a tect box control in the report with source =Forms!MyForm!FromDate

you need to use your own form and control names of course



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[THWatson]

Randy
Ken is absolutely right that a good way to call your dates is from a form. I was just providing you with a quick way to do it from the query.

I also wanted to mention that, for some reason, when my post was submitted the quotation mark (&quot at the beginning of my text box statement was removed. There should be " between the = sign and This.

I'll type it again and see if the " is removed again.

="This report covers information between " & [start date] & "and " & [end date]

Tom

 

[RandyMcI]

Thank's Ken, worked like a charm.

I also tried Tom's method. But it asked me twice for the dates.

Randy

 

[THWatson]

Randy
Glad that Ken's method worked. That's the important thing. And as I indicated earlier, the "query by form" method is better anyway.

As for being asked twice for the paremeters, the only time I have been asked twice is when I haven't called the parameters exactly the same in the report as I did in the query. It only takes a single character difference to cause it to happen.

Tom

 

[RandyMcI]

Tom,

Your reply makes sense, as I cut and pasted your exact line from above, without changing to match what I had put in my query.

Thank you

Randy

 

[THWatson]

Randy
Aha! The old cut and paste method. That'll confuse even Access!

Good catch.

Tom