Printing entered parameters in report 2

[AngusCampbell]

I have parameters such as @StartDate and @EndDate in my report. (For V.90/ MS Access)

In the header, I wish to print these so the reader knows what date range the report is for. For example in a text field I have ...

For Period {@StartDate} through {@EndDate}

This works, but prints only the date range RETURNED, not the ones ASKED for (entered at prompts). In other words when you select a range of 12/1/04 through 12/15/04, it would print the dates 12/02/04 through 12/14/04 if there happened not to be records for the dates 12/1 or 12/15. This can be misleading to the reader.

Any ideas?

Thanks and Happy New Year

 

[Nuffsaid]

Hi

Create a formula to display your parameters ie;

"For The Period "+totext({?Start_Date}, "MMMM dd, yyyy")+" "+"To"+" "+totext({?End_Date}, "MMMM dd, yyyy")

If your parameter is a range try;

"For The Period " + totext(minimum({?DateRange}),"MMMM dd, yyyy") + " To " + totext(maximum({?DateRange}),"MMMM dd, yyyy")




Nuffsaid.

 

[kskid]

Assuming ?daterange is your parameter, then

"For Period " + totext(minimum(?daterange),"MM/dd/yyyy") + " through " + totext(maximum(?daterange),"MM/dd/yyyy")