Re: On Time Delivery Query

WOW.....Thanks for the quick response and it works. I was amazed!


"Al Campagna" <newsgroups@xxxxxxxxxxx> wrote in message news:%23RfXlnnbIHA.5164@xxxxxxxxxxxxxxxxxxxxxxx
John,
= IIf([ShipDate]<=DateAdd("d",-3,[DueDate]),"Early",IIf([ShipDate]>=DateAdd("d",-2,[DueDate]) And [ShipDate]<=[DueDate],"On Time","Late"))

Please check my syntax for "finger checks", but that should do it.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


"John Torres" <johntorres@xxxxxxxxxxxxxxxxxxx> wrote in message news:AE539D76-7D35-4062-8F8B-1CCC160A6AC9@xxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: On Time Delivery Query
    ... Please check my syntax for "finger checks", ... Microsoft Access MVP ... Date or 2 days early) and LATE (Shipped past Due Date) and on a business ...
    (microsoft.public.access.reports)
  • Re: Syntax error DateDiff
    ... Microsoft Access MVP ... and you'll never work a day in your life." ... get a message that the syntax is wrong: ...
    (microsoft.public.access.formscoding)
  • Re: On Time Delivery Query
    ... If ShippedDate is 3 days or more less than DueDate = Early ... Microsoft Access MVP ... name like ShipStatus. ...
    (microsoft.public.access.reports)
  • Re: On Time Delivery Query
    ... Microsoft Access MVP ... and you'll never work a day in your life." ... name like ShipStatus. ...
    (microsoft.public.access.reports)
  • Re: On Time Delivery Query
    ... Microsoft Access MVP ... The totals for each group should be done on the report footers, ... like ShipStatus. ...
    (microsoft.public.access.reports)