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

CONCATENATE to remove duplicates NOT working

Status
Not open for further replies.

rwn

Technical User
Dec 14, 2002
420
US
I have these fields in the Detail Section: Job, Vendor, Invoice#, PO, POLN, Invoice$, Invoice Status, Paid$

and using this: {@conccat}= Job & Vendor & Invoice# & PO & POLN & Invoice$
Then go to the section expert->details->suppress->x+2 and enter:

{@concat} = previous({@concat}) :

But when the duplicates are removed and records are viewed ALL the date is correct except the Paid$ field only shows the same value in each row and it should be showing a unique value in each row.

if I then have: {@conccat}= Job & Vendor & Invoice# & PO & POLN & Invoice$ & Paid$

Then the Invoice$ field always shows the same value in each row.
 
Personally I would avoid complicated ways trying to suppress rows and figure out why I have duplicates in the first place (bad table joining?). Also I am a big fan of doing groupings and only displaying data in the group footer (avoids a lot of duplication issues).
 
Im not a fan of dups either. But this has nothing to do with linking or such at all. It has to do with Checking being applied multi Times to Invoices.

I used above what LB recommended and was wondering if he had any insight.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top