Suppressing repeated data

decie

New member
Local time
Today, 16:31
Joined
Jun 3, 2003
Messages
9
:confused: I have a report where only the invoice number and invoice amount fields duplicate with each record related to that invoice. How do I prevent the invoice number and amount from repeating on each line except for the first instance? Thanks so much for all your help.
 
Set the "Hide Duplicates" property for those textboxes to Yes.
 
That is just too easy!!! Thank you! In thinking ahead, how would I accomplish this if I needed to hide duplicate from one field, only if 2 would duplicate?

For example,
Acct# Amt
1123 25.00
1123 25.00
1124 25.00

In the example, I would only want to hide the 2nd 25.00 but show the account number. What I am not showing is the remaining fields contain unique data for each record line.
 

Users who are viewing this thread

Back
Top Bottom