Query a Time Range

[RichFost]

I have a data table in Access97 which records, amongst many other items, the date and time that a line of data was entered.

I want to be able to run a query where I can select records entered between two specific dates and two specific time ranges.

I've tried using: >=[Record Start] And <[Record End] for both the date and time fields but this only seems to select the specific date, and ignores the time range i've entered.

Can anyone help ?

Thanks.

 

[Norie]

Are the time/date in the same field or are they seperate?

 

[Cbrine]

I use

Between [Record Start] and [Record End]

to select date ranges. It should work with time ranges as well.

HTH
Cal

 

[RichFost]

Hi,

The time and date data is in the same table but in different fields.

I've tried the Between command, but it wouldn't work for the time field.