Avery No of days late query

jai

I need to find the average number of days late for each supplier, each hav more than one order. how can i group the suppliers orders and find the average :S

shud i do this in a report? i have worked out the number of days late for each order using DateDiff function

PEB

Hi,

You should create an aggregate query pressing sigma sum buton in query design!

Then you assign supplier for group by and under day late you put Average

This query will show you average day late by supplier!

Avery No of days late query

re: Avery No of days late query

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about