For report with multi-types, only show first occurence of Cust Nam

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example, if i I have the following table as recordsource:

Type Cname Amount
Sales Jay 8
Sales Jay 7
Sales Jay 9
Returns Jay -2
Returns Jay -8

The report uses the type field for grouping. With Hide Duplicate Cname the
report appears as (i hide the Type altogether):

Jay 8
7
9
Jay -2
-8
Total 24

What I want is:

Jay 8
7
9
-2
-8
Total 24

The Name on appears once.
 
Add a group header for Cname and place a text box bound to Cname in the
section. Don't bind the Cname field to any controls in the type or detail
sections.

Add code to the On Format event of the Cname header section:
Me.MoveLayout = False
 
Back
Top