Time Frame Query

[cardak]

I have an Access database table that collects "IncidentDate" and
"IncidentTime" as two seperate fields. I am trying to write a query that
will return records that occurred between a certain "IncidentDate" and
"IncidentTime" and another "IncidentDate" and "IncidentTime", say between
08/08/208 08:00:00 and 08/09/2008 08:00:00. I can get the query to pull the
data except that it includes all records on and between the two dates
including those outside of the time parameters. I've tried formatting the
two fields into a common field with a "between' criteria, but it returns no
records. Any suggestions?

 

[pietlinden]

I have an Access database table that collects "IncidentDate" and
"IncidentTime" as two seperate fields.  I am trying to write a query that
will return records that occurred between a certain "IncidentDate" and
"IncidentTime" and another "IncidentDate" and "IncidentTime", say between
08/08/208 08:00:00 and 08/09/2008 08:00:00.  I can get the query to pull the
data except that it includes all records on and between the two dates
including those outside of the time parameters.  I've tried formatting the
two fields into a common field with a "between' criteria, but it returns no
records.  Any suggestions?

Why are the date and time separate? They should be in the same field
as a general date. Then you can do date math any way you want.

 

[cardak]

Thanks, sometimes you can't see the forest for the trees. Your solution
worked beautifully!