counting number of rows which contain the same Part No.

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??

re: counting number of rows which contain the same Part No.

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! :)