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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display only one of a duplicated field, but....

Status
Not open for further replies.

Newbie69

IS-IT--Management
Mar 2, 2002
5
US
I only want to display one of the duplicated ID's, but I want to add a field together each time that Id exists and this is true for all the fields and their duplicates.

Can anyone help me write this formula, or tell me if it's possible
 
If by "add" you mean "sum" then simply group by the
ID field, suppress the details and show the ID
and a sum in the group footer.

Cheers,
- Ido ixm7@psu.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top