i have a list of suppliers, each supplies one part for each order
so i have a long list of suppliers most of with are duplicated. how do i count the number of orders the supplier has and use this number to calculate the average number of days late which i have already worked out, do i have ot use SQL??
jai
Last Activity: May 7 '06, 05:19 PM
Joined: May 7 '06
Location:
-
counting number of rows which contain the same Part No.
-
Avery No of days late query
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 -
HELP!! going to go mad soon!! query help
Hello all thank you for lookin at my problem :)
I have a database which consists of 3 tables and im not allowed ne more, and i hav a set amount of fields and im not allowed any more!
i need to find the average number of days late for each supplier, but i need to find the number of days late first!! i cant store the number of days late anywhere which would make it easy to workout the averyage.
i know id...
No activity results to display