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?

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

Col

couldnt get that to work hey http://www.access-programmers.co.uk/ubb/frown.gif it just pops up a box asking for the value

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

Col

hey col, thanks for persisting http://www.access-programmers.co.uk/ubb/smile.gif
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..

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

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

cheers dude