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?

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

"Mike Hunt" <(E-Mail Removed)> wrote in message
news68B2FD9-D8D8-41C0-8CEB-(E-Mail Removed)...
>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?
>