Nightspawn
New member
- Local time
- Today, 10:17
- Joined
- May 10, 2007
- Messages
- 3
I am having difficulty in generating a report ~ have searched count on the report forum but nothing seems to match what I am looking for.
I am trying to count field values in a report.
The table I am using is a sample customer table and has these fields:
Name
Add1
Add2
Add3
Town
County
Postcode
PCArea
The report I am trying to make uses values from the Postcode Area field (PCArea), what I would like the report to do is list all the different Postcode Areas (About 120 different) and then count and display the number of customers within each area.
So something like:
Postcode Area CM 25
Postcode Area CO 12
And so on for all the different areas.
Any help offered will be very gratefully received ~ thx
I am trying to count field values in a report.
The table I am using is a sample customer table and has these fields:
Name
Add1
Add2
Add3
Town
County
Postcode
PCArea
The report I am trying to make uses values from the Postcode Area field (PCArea), what I would like the report to do is list all the different Postcode Areas (About 120 different) and then count and display the number of customers within each area.
So something like:
Postcode Area CM 25
Postcode Area CO 12
And so on for all the different areas.
Any help offered will be very gratefully received ~ thx