How do I separate a date/time stamp in Access 2007? I need to be able to query for certain times of day over a period of 120 days (i.e. create a query that only gives me the data for 1pm, irrespective of the date). Any suggestions?

Thanks ChipR. I'm new to access so trying to figure it all out. another question for you (this is going to seem dumb), what do I enter into the ([dateField])? If I want temperatures for certain times of day from June15 through August13?

I have temperature data loggers that record temperature every 6 minutes for 120 days. When I upload the data to access the date/time field is automatically formatted from the data loggers to be in this format: 6/15/2009 12:06:00 AM. What I need to do with the data is look at certain time frames over the entire 120 day period (i.e. from 12pm to 9pm every day). How can I run a query to get just those times over that entire period? I've tried doing...