Determining if a time falls inbetween two time values

[CTOROCK]

My calculations need to discount the time taken for breaks and lunch. All breaks and lunches are taken at the same time so I wanted to say if 10:00 fell inbetween the start time and end time, then discount 15 minutes from the total. I did something like this:

if #10:00# > dtstart & < dtend then...

but that is not the correct format. How can I do this

Thanks! &quot;The greatest risk, is not taking one.&quot;

 

[RobBroekhuis]

What application? Rob

 

[CTOROCK]

Sorry, am using Access 2000.

Thank You &quot;The greatest risk, is not taking one.&quot;

 

[RobBroekhuis]

I was afraid of that. It's easy in Excel, others will be able to help you in Access.
Rob