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

counting number of rows which contain the same Part No.

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

Expert 100+
P: 1,418
Yes, You can use the query design builder to build your query:
You open a new query and using the Add table bouton you add the table with Suppliers and parts...

Then You have to press the sigma buton /total/ and click 2 times on supplier
Under the column supplier that will apear in the grid you choose group by!
You click an other time on supplier and this column reappear... This time you choose instaed group by the function Count...

When You press the buton Datasheet View in left you will see a query with the count of details by supplier!

Have a nice luck with queries! :)
Sep 3 '06 #2

Post your reply

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