help -

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access 2000, I have been asked to create a report, by date range that
will provide on time percentages of orders processed. Question is - HOW?

I have a "DateIn" field which gives the date the order was received and
entered into the database. Also, there is a "DateDhipped" field which gives
the date the order shipped, and a "DateDue" field which gives the date that
the order is due to the customer. I'm very new at this, and unsure how to
create this query / report. Please help
 
Gary,

Here's one idea...

1. Make a query based on your table, and in the Field row of the
query design grid, put this:
OnTime: [DateShipped]<=[DateDue]
This will evaluate to -1 (Yes) if the shipment was on time, and 0 (No)
if not.
2. Make a report based on this query. Just have a textbox in the
Detail section of the report bound to the OnTime field. But is you
don't actually want to see this (or other fields you might want
included in the report), you can set the Visible property of the
report's Detail section to No.
3. In the Report Footer section, put an unbound textbox. Change the
label to 'Percent shipped on time'. In the Control Source property of
the textbox, put:
=Abs(Sum([OnTime]))/Count(*)
Set the Format property of the textbox to Percent.

Hope that gives you a start.

- Steve Schapel, Microsoft Access MVP
 
Back
Top