me again..how to display the criteria in reports (1 Viewer)

[sloth]

hi im using the old 'Between [Enter Start Date] and [Enter End date]' but i need to get these values to display on the report, as im summarising the records retrieved between these dates but the report doesnt give any indication of the timeframe..

the query doesnt appear to save these variables..any ideas?

 

[ColinEssex]

In the report header put [Enter start date] and [Enter end date]

Col

 

[sloth]

couldnt get that to work hey

it just pops up a box asking for the value

 

[ColinEssex]

don't forget it needs to be EXACTLY as it is in the query

Col

 

[sloth]

hey col, thanks for persisting

yeah it is, i even changed it to just an E and that didnt work, tried using the builder to put the query name in front as well, just comes up with something about not having an automated event..

 

[ColinEssex]

ok - lets crack this once and for all

In the report header create a text box

In the control source put [Enter Start Date]

It WILL work !!! I've just done it

Col

 

[sloth]

hey col THANKS it worked, the error came from somewhere else, but i redid the report and bingo...

cheers dude