Duplicate records Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Duplicate data 1
Supress Counting of Duplicate Primary Keys 2
Record omission 2
Help me count records without duplicates 3
Access Auto Matching Duplicates? 0
report creating a fake duplicate 2
Not Counting Duplicates in a Report 3
Count Function (conditional counts) in Reports 3

Back
Top