Append fields of one record to another

[shawnj985]

How can I append a county field of other records with the same zip code to another field to display in my report and reduce the number of records in my found count at the same time.

Please see the attachment for a clearer explanation.

New_report.pdf

[MarkWilson]

Here is one way.

Counties.zip

[shawnj985]

Thanks, i will give that a try.