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!

Duplicate Problems

Status
Not open for further replies.

tedi1

Technical User
Aug 25, 2002
87
IL
I'm creating a report and I'm getting some duplicates. how can i reffer only to to one of the items in the group? it can be dine by "GROUP BY" in sql but when I try to change the Query it just disregards the "GROUP BY".
what should I do?
 
Can you verify that the linking between the tables is accurate? Inappropriate linking will produce duplicate data.

Alternatively, if the links are correct, you could create a group in the report, and place your data in the group footer instead of the details section, which will return the last value per group returned from the database. You could also use the previous or next functions to produce the same thing.

Naith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top