Summarize a series of value entries

[jess]

FM8 Pro

Trying to summarize precinct results for a particular race. Most records are listed as follows:

Precinct# Rep Dem

2102 34 87

2103 56 98

2104 88 53

The above is what I want..but sometimes the data is as follows:

Precinct Rep Dem

2103 55 50

2103a 25 15

2103bg 10 5

There really isn't too much of limit of the extension of the precinct. The sub precinct might be denoted with the letter "a" or "ab" or "bg" or "cde". Not a whole lot of ryhme or reason.

How can I summarize each sub-precinct into a single precinct tally?

So that the end result is:

Precinct# Rep Dem

2103 90 70

2104 55 86

2105 45 21

Thx..

Jess

[mr_vodka]

Depending on your data for Precinct number, you can create a calc field and group your summary report by that field.

If it will ALWAYS be the first 4 characters, then you can use Left (PrecintNum; 4) or if it will always be numbers, then you can use something like Filter ( PrecintNum; 1234567890 )