Display Unique Zip Codes From Query in Report

[dascoli]

I have a query that displays unique clients based on a specified date range. I built a report based on this query to count how may of these unique clients are employed or unemployed and placed these counts in the report header.

I want to be able to display unique zip codes for these clients that we had contact with either in the form header or detail. When I place the zip code field in the header it only displays the first client's zip code. When I place it in the detail section, the report displays all the field values (non-unique). I tried to make another query to base a subreport on that displays only unique zip codes, but even when I only include the zip code field and the contact date field it finds unique clients, not zip codes.

I am at a loss for how to accomplish this. Any help is greatly appreciated!



UPDATE:
I got another query to return unique zip codes by running the second query based on the first query. I still cannot get these results to display properly on the report though.

[orange]

I'm not sure what you are really asking. If you want clients (plural) they may reside in the same or different zip codes.
If you only want to show 1 client per zip code, which client would that be if there were 6 clients in that zip code?

Perhaps you could provide an example of input and desired output.

To get unique clients

SELECT DISTINCT ClientID FROM tblClient;

[dascoli]

The idea is to only show the zip codes. I think I managed to get it working by using a subreport that is based on the second query I created and not have it linked to the primary report. I have to do a little more testing though to make sure this worked.

The report looks like this though:

Total Clients-4
Employed Clients-1
Unemployed Clients-3

Zip Codes Served-00001,00002,00003,00004

Or

Zip Codes Served:
00001
00002
00003