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

Duplicate records

Status
Not open for further replies.

Krusher

IS-IT--Management
Jan 2, 2003
70
US
How can I suppress a record in details if it is a duplicate of a group name. Meaning, if I have two fields, from two different tables and with the same data, how can I suppress one against the other? Basically, two separate tables contain the same data and I want to suppress only the record in the details field. The grouping record is actually from an alias table.
 
Why do you have both tables if they're identical?

Anyway, I'll assume that there's lots more to your question and respond with the generic statement to group by that field and display in the group header, suppressing the details and group footer.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top