User prompt date criteria not including end date

[Lynn73]

I have set up a report which prompts the user for a start and end date. However, if they want to run it for a full month they enter eg. 01/07/07 and 1/07/07 - this will not include entries ending on 31/07/07.

Is there a way I can change the criteria prompt so that it read both dates entered as inclusive in the query. I am currently using
Between [enter earliest date:] and [enter latest date:]

 

[EMP]

If the date field contains also the times, see discussions in this thread.
http://www.access-programmers.co.uk/forums/showthread.php?t=134835

^

 

[RuralGuy]

Between *is* inclusive but without specifying the time, midnight is assumed. Midnight is the beginning of a day and will probably eliminate everything on the last day so the easiest fix is to add 1 to the ending day.

 

[EMP]

Adding 1 day to ending date works so long as there are no records exactly at mid-night.

^

 

[RuralGuy]

EMP,
Correct! It is a consideration and should be allowed for.