Date and Time Reporting

[Guest]

I am accessing a POS System thru a ODBC Driver, the Transaction date and time
are held in 2 fields in the POS System. I can concatenate the Date and Time
in the following format 01/06/2006 5:49:03 PM with a query.

When I try run the same query with selections between 01/06/2006 5:00:00 PM
and 02/06/2006 2:30:00 AM. It will only display the 01/06/2006 transactions

Can anybody help with this problem please?

 

[Arvin Meyer [MVP]]

Save the query with the concatenated column. Open a new query using the new
column from the first query. Remember that SQL is written in US Date format,
(mm/dd/yy) so you'll need to write the second query like:

Select * from Query1 Where Query1.NewDateField Between #6/1/06 5:00 PM# And
#6/2/06 2:30 AM#;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access