Supress rows in report

[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.

 

[OfficeDev18 via AccessMonster.com]

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.

Without seeing your SQL, it's kinda hard to get specific. However, in general,
the idea is to add to your SQL stqtement as follows:

WHERE SalesDollarsField > 0

If you already have a WHERE clause, just add: And SalesDollarsField > 0
This will remove all your blanks.

 

[Marshall Barton]

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

To suppress the details in the <40 group add a line of code
to the group header section's Format event:

Me.Section(acDetail).Visible = (Me.groupingfield =
"whateverthequeryhas")