Help with a query

  • Thread starter Thread starter OverMyHead
  • Start date Start date
O

OverMyHead

I am trying to create a query that uses time and I need some help.

I have 2 columns that have a start time and an end time and both are
formatted as 1:30 PM

I need to create a query that shows all records where the End time is
< 10 minutes from the start time.

Is this possible?
 
You can create a new column in the query grid:

TimeDiff: DateDiff("n",[StartTime],[EndTime])

set the criteria under this column to
<10
 
Back
Top