Turn this query into a parameter query

[Peter Allanach]

Can anyone advise me on how I can modify the criteria -
"Between #12/03/2004 17:00:00# And Date()+#17:00:00#" so
that the Date and Time at the beginnning can be entered by
the user as a parameter

 

[Michel Walsh]

Hi,



BETWEEN [Date and time of start, dd/mm/yyyy hh:MM:ss ] AND Date() +
#17:00:00#



or

BETWEEN [Date and time of start, dd/mm/yyyy hh:MM:ss ] AND Date()
+TimeValue( CStr( [Date and time of start, dd/mm/yyyy hh:MM:ss ] ))


if the same time should be use for the second limit.




Hoping it may help,
Vanderghast, Access MVP