Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Displaying Duplicate Numbers
- Thread starter dg3249
- Start date
synapsevampire
Programmer
If you have duplicate invoice numbers within each client, than you'll have to discover another field to group on to make them unique (invoice numbers should ALWAYS be unique).
If you have unique invoice numbers per client, than group by client and then by invoice (invoice will be a subgroup of the client), you should get the expected result.
A Group is a distinct data set, so you will not get duplicates at a group level for the same entity. You can place fields in the details section which will show all of the rows for that grouping.
-k kai@informeddatadecisions.com
If you have unique invoice numbers per client, than group by client and then by invoice (invoice will be a subgroup of the client), you should get the expected result.
A Group is a distinct data set, so you will not get duplicates at a group level for the same entity. You can place fields in the details section which will show all of the rows for that grouping.
-k kai@informeddatadecisions.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question