Date range to print on the report 1

[TadyB]

Hey.
I have an invoice report with a query that prompts the user for a date range based on the InvDate. Is there an easy way to get that date range printed on the report?

I don't have my invoice items listed individually, just the total for items purchased for that date range. I would like to have a line that reads: "Snack Bar charges from (Begin Date) through (End Date)."

Thanks,
Stacey

 

[scriverb]

If the Record Source query is prompted for the Begin and End dates then there are designations in the SQL that can be used just like variables in the report.

Example:

Select A.*
FROM yourtablename as A 
WHERE A.InvDate Between [red][Begin Date][/red] and [/red][End Date][/red];

Look for the prompted variables within the Square Brackets in your SQL. You can use them just as stated(exact spelling of course) in the query in your report text control for display purposed. In your control on your report use something like the following:

="Snack Bar charges from " & [Begin Date] & " through " & [End Date] & "."

Post back if you have any questions.


[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[TadyB]

OMG...that was so cool!

I've never looked in my SQL before...so much to learn...it works perfectly...thanks sooooooo much!!!

Stacey

 

[scriverb]

Glad to be of assistance. Thanks for the Star.

You definately want to learn SQL as there are times where the QDW in ACCESS queries cannot produce easily the code that is necessary. The best way to learn is to create a query in the QDW and then open the SQL window and see how it converted to the actual programming language.

Good luck.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[TadyB]

Ok, thanks...I will try that...can't wait to learn!

Stacey