By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

Avery No of days late query

P: 3
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
May 7 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

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!
Sep 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.