Duplicate records Problem

Good morning.

I am writing a query that uses selected data from two tables. The results
then go into a summary report. We want to remove the duplicated data. I
tried the 'hide" feature in the report but it does not work for summary
reports. What is the best way to remove duplicated data from a summary
report? For example in a CUSTOMER - ORDER relationship, we want to count the
unique CUSTOMERS by zip code.

Thanks.

You may need to change the type relationship so you do not get dupes and then
turn on the hide duplicates in the report also.

Need more info can you explain your query and results alittle better would
help.

Keep it simple but don't loose the idea behind the query.


--
Hansford D. Cornett


"Chuck" wrote:

Good morning.

I am writing a query that uses selected data from two tables. The results
then go into a summary report. We want to remove the duplicated data. I
tried the 'hide" feature in the report but it does not work for summary
reports. What is the best way to remove duplicated data from a summary
report? For example in a CUSTOMER - ORDER relationship, we want to count the
unique CUSTOMERS by zip code.

Thanks.