Need advice

[eyeguy]

Hi guys

I need some advice on performing what I assume is a basic function.

I have a dataset of patients with their postcodes(zipcodes).

I need to determine how many live at any given postcode and ideally display the count of each given postcode on a graph.

I can think of ways using relationship with a given post code as a match field but that would involve creating thousands of relationship.

Is there an easy way of doing this?

Joseph

[Vaughan]

Create a summary report based on the postcode. Use the new layout report wizard.

[djlane]

Eyeguy,

You can use the UniqueValues Custom Function http://www.briandunning.com/cf/596

Use a self join, and make a calculation field, eg. ZipCodeListAll which is List(related::ZipCode). That gives you a field containing a list of all the zip codes. Then create another field UniqueValues(ZipcodeListAll).

You could also use a script to set these fields instead of using calculations, which might be a little slow to display.