Unique and Count How best to Show Data

[DaveT99]

I have a list of spare parts with 3 fields a) Unique Part No, b) Spare Type e.g Bearing and c) Mfg, the queries created below I ignored the Unique Part No



For a single noun, e.g. BEARING i first did a Parametric QUERY based on the Table
Then I made a 2nd query based on the 1st query to show that they stocked bearings from 32 different manufacturers
Then I made a 3rd query also based on the 1st query to show the number of bearings stocked per Mfg

My problem is how to get this data for all part types, e.g. BUSH, CONTACTOR etc in a single output

Which would be the best approach?

[isladogs]

You can do that in one query.
Open the query designer and add your parts table
Click the Totals button in the design ribbon

Now add the fields SpareType and Mfg. You will see each has group by under the field name.
Now add Unique Part No and change the 'group by' to Count using the drop down.

If I've understood you correctly you should now have the number of parts of each type grouped by manufacturer.

[DaveT99]

Hi Ridders52
Thanks for the help, your suggestion worked perfectly and then used this query to count the number of Mfgs for any part type
Thanks again
wonderful support and quick

[isladogs]

You're welcome