G
Guest
I am working on a sales report. In my report I want so summarize all
customers with sales less than $x, and show detail (cust name, etc) for
customers with sales over $x. In my query I have marked each record to fit
into one of these categories, and have designed my report to group on each,
with a subtotal for each. My probelm is that I keep getting the blank rows
to show up for the less than $x section. How can I suppress these to only
get 1 (or 0) blank row and a subtotal for the section?
Using the data below i want my report to look like the following.
Cust A $50 in sales
Cust B $45 in sales
Cust C $30 in sales
Cust D $20 in sales
Report layout:
Sales > $40
cust A $50
cust B $45
Total Sales > $40 $95
Sales < $40
Total Sales < $40 $50
Total Sales $135
Thanks in advance for any help/suggestions.
customers with sales less than $x, and show detail (cust name, etc) for
customers with sales over $x. In my query I have marked each record to fit
into one of these categories, and have designed my report to group on each,
with a subtotal for each. My probelm is that I keep getting the blank rows
to show up for the less than $x section. How can I suppress these to only
get 1 (or 0) blank row and a subtotal for the section?
Using the data below i want my report to look like the following.
Cust A $50 in sales
Cust B $45 in sales
Cust C $30 in sales
Cust D $20 in sales
Report layout:
Sales > $40
cust A $50
cust B $45
Total Sales > $40 $95
Sales < $40
Total Sales < $40 $50
Total Sales $135
Thanks in advance for any help/suggestions.