Hello,
Is there a way to show just the number of records and nothing else in a query?
My table has over 21,000 records in it. All part numbers.
I have made different queries of each of the brands of parts.They all work great, thank you for showing how to do this.
I would like a query to show how many of each brand of part is in the database with just 1 query.
Each brand of parts starts with 101 then a letter for the brand of part, then a /.
An example of this would be: 101A/ followed by the number.
I would like a query to show how many of brand A, brand B and so on.Just how many different parts for each. My individual queries show all the other relevant information.
As Richard always says, "There is a way to do just about anything in access".
Thank you so much.