Count Query

[DJM1216]

I'm hoping that this is a "simple question".

I'm running a count query but I want the data to be returned in addition to the count totals.

For example I'm running a query on number of customers by zip code. My fields chosen for the query are "Zip Code" and "City". When I select count, no value is returned in the zip code column.

I would like my final output to be "Zip Code, City, Count".

 

[Sully38]

Make sure you are grouping on zip code and city . Then add zip code a second time and make sure its grouping option is set to count. It should work.