Suppress label print

[ajarrell]

I am printing invoices and need to print the label in a subreport at the end of each customer only once. This is what I want it to look like:

2014 payments applied to cap: GA $8,078.00
NC $1463.00
SC $155.00

NOT

2014 payments applied to cap: GA $8078.00
2014 payments applied to cap: NC $1463.00
2014 payments applied to cap: SC $155.00


I use ACCESS, but I do not know SQL. Any ideas? Thank you.

 

[vbaInet]

1. Which part of the string is built from the Record Source?
2. Is the report grouped by Customer?

 

[ajarrell]

The state and dollar amount are from the record source.
Yes, the report is grouped by customer, and this sub-report is at the end of each customer group.

 

[vbaInet]

Two things to try:

1. Convert your label to a textbox and set the Hide Duplicates property to Yes

OR

1. Create a textbox in the section and enter =1 in the control source
2. Set the Running Sum property of the textbox to Over Group
3. Convert the label into a textbox and use the value from the textbox in step 2 to control when to display the text

=IIF([txtRunningSum]=1, "2014 payments applied to cap: ", Null)

3. Or set its Can Grow and Can Shrink property and use the same code above

 

[ajarrell]

The Hide Duplicates worked perfectly!
Thank you so much!

 

[vbaInet]

You're welcome!