Prev: auto copy
Next: Keep Sub Report From Rolling to Next Page
From: Fred's on 7 Jul 2008 16:45
Hello,

On my report, I have the following formula into a text box which
calculate how many shipment not on time.
=Count([Store])-Sum(nz([Différence D'Heure],0))

And this other formula that calculate how many stores I have
=Count([Store])

Now i will like to calculate how many shipment not on time.
but in pourcentage.

What will be the formula?

Thanks for your help!

Fred's
From: Douglas J. Steele on 7 Jul 2008 18:15
That would be the number of late shipments divided by the total number of
shipments.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Fred's" <frederic10_mess(a)hotmail.com> wrote in message
news:c50a7b1f-9c34-4661-8f31-af0238e14507(a)d45g2000hsc.googlegroups.com...
Hello,

On my report, I have the following formula into a text box which
calculate how many shipment not on time.
=Count([Store])-Sum(nz([Diff�rence D'Heure],0))

And this other formula that calculate how many stores I have
=Count([Store])

Now i will like to calculate how many shipment not on time.
but in pourcentage.

What will be the formula?

Thanks for your help!

Fred's


 | 
Pages: 1
Prev: auto copy
Next: Keep Sub Report From Rolling to Next Page