Turn this query into a parameter query

  • Thread starter Thread starter Peter Allanach
  • Start date Start date
P

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
 
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
 
Back
Top