Repeating Values

[EagerBeaver]

Just a general question. Many times I have created a report in which I get duplicates. I know these duplicates can be suppressed but sometimes I get duplicates later in some other pages.

Does anyone know why I would get all these duplicates?

 

[MalcolmW]

It really depends on what you mean by duplicates. Frequently one field is duplicated many times, for example the State in a list of addresses, or the customer ID in a list of invoices.
You can also get duplicates if you are linking several tables, such as Customers and Orders. The information from the Customer table will be shown once for each order for that customer.
You can also get duplicates if you are linking several tables, and the join is not completely defined.
You can also get duplicates if you have duplicates in the database.
You can also get duplicates ....and so on. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[EagerBeaver]

I believe my problem comes in the linking portion. But thanks...thats good to know

K