Using Date in Query

[tubbers]

I have a field called FirstDetect which is in a Date/Time format. I need to be able to run a query which would let me select records that have a FirstDetect value between say "0:00:00" and "1:00:00". How would I structure that query? I tried the following:

SELECT MasterData.TotalHits
WHERE MasterData.FirstDetect BETWEEN "0:00:00" AND "1:00:00";

but got the following error:

"Data type mismatch in criteria expression"

I'm sure its just something simple like the format of my query but I can't figure it out.

Any suggestions?

Thanks.

 

[dhookom]

Date/time fields are delimited with "#" in Access. Try:

SELECT MasterData.TotalHits
WHERE MasterData.FirstDetect BETWEEN #0:00:00# AND #1:00:00#;


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[tubbers]

Thanks! That was simple and it worked just perfectly.