On Time Delivery Query

From: "John Torres" <johntorres@xxxxxxxxxxxxxxxxxxx>
Date: Wed, 13 Feb 2008 12:22:56 -0600

I'm trying to create a query for "On Time Delivery". I have query fields of PO, Date Received, Due Date and Date Shipped. I'd like to calculate EARLY (shipped 3 days early from the due date), On Time (Shipped on Due Date or 2 days early) and LATE (Shipped past Due Date) and on a business days only (excluding Saturday and Sunday). These are all coming from 3 different tables. I would appreciate any ideas.

Thanks,

John

.

Follow-Ups:
- Re: On Time Delivery Query
  - From: Al Campagna

Prev by Date: Re: Days late on payment using Date()
Next by Date: Re: open form multiple times
Previous by thread: RE: Error setting Rowsource using VBA for Chart
Next by thread: Re: On Time Delivery Query
Index(es):
- Date
- Thread