Criteria for Date/Time Field - Cumbersome

[tbl]

When I want to quickly query for a certain date, on a field
that is a Date/Time datatype and contains both date *and*
time information, it sure seems a pain to have to use the
"between" statement. Is there a better way?

 

[Ken Snell \(MVP\)]

Sure -- use a query like this:

SELECT * FROM Tablename
WHERE DateValue([DateTimeFieldName]) = #06/29/2006#;