Re: On Time Delivery Query

Is there any way to summarize the total of Early, On Time and Late on the query or report?
Thanks again!
John


"John Torres" <johntorres@xxxxxxxxxxxxxxxxxxx> wrote in message news:B1171988-68AA-447B-9AB8-48A8E9C9088B@xxxxxxxxxxxxxxxx
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: Print report based on value of 2 combo boxes
    ... What I need is the syntax for the rest of the DoCmd.Openreport..... ... The report "AllComputers" will be used for many different queries, ... the computers in the table" to a "particular computer" ... > boxes on the form to filter the query behind your report. ...
    (microsoft.public.access.reports)
  • Follow-up : Parameters using Between Date 1 & Date 2 - Need to use Like too!
    ... "Kahuna" wrote in message ... > I have a parameter query feeding a report. ... > the code once before but cant seem to get the syntax right now. ...
    (microsoft.public.access.queries)
  • Re: Standard Deviation
    ... I would look at the query "SLA S-04 Query 3" to see if ... or DStDev on a report? ... > syntax StDev or StDevP does not work? ... >> Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.reports)
  • Re: Print report based on value of 2 combo boxes
    ... What it does not do is close the input form after the report appears. ... boxes that gets its options from a special table I use to keep track of all ... the formula (Syntax) that you gave me seems ... boxes on the form to filter the query behind your report. ...
    (microsoft.public.access.reports)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)