count items in a grouped in a row?

[supdawg]

Hey guys, I'm relatively new to Access. I have a query that I am grouping a bunch of tables together based on order number and what I need to know is how many purchase orders comprises my order number?

I am grouping by purchase order, but I want to know how many purchase orders per order number.

Can I count the number of unique PO's tied to that order number if its grouped by PO?

 

[Joe4]

If you are "grouping" them, it sounds like you are already creating Aggregate Queries. Note that when you "Group By" certain fields, you can perform other functions on the other fields, like COUNT, SUM, MAX, MIN, etc.So just include the field you want to count, and change the Totals Row value for that field from "Group By" to "Count".

If you have duplicates, and want to count the unique values of that field, you may need to do this in a series of two aggregate queries:
1. Include the PO field in your initial Aggregate Query where you are just Grouping everything.
2. Create a second aggregate query based on the first, where now you are using the COUNT function on your grouped PO field.