Displaying data from either of two queries

J

Justin

I have created a report that lists on duty hours for each driver along
with a column showing a sum of the previous six days. When a driver
has been off duty for over thirty-four hours, the total needs to be
reset to zero. Should I create a subquery in order to do this or is
there an easier (better) way to accomplish this?

TIA for any help.

Justin Thomsa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top