Help Needed

[Danu]

Hi -

I have a table of about 360K records. Here is the format:

CODE
ACCOUNT NUMBER
DESC
COST
DISCOUNT

All records have a code, account number, desc and cost. Not all records have
a valud in the discount field.

I need a summary report:

CODE COST # of accounts with DISCOUNT # of accounts without DISCOUNT
TOTAL

It does not matter what is in the discount field, just if there is or is not
a value.

I have gotten myself in a tangle trying to use group headers. I know it must
be a simple thing. One line for each code. By the time it is all worked out,
there should be about 10-15 lines for each code.

BTW, this is a subreport. The main report lists ALL the information for ALL
the records.

THANK YOU!!

- Danu

 

[Allen Browne]

In query design view, type this into a fresh column in the Field row:
NoDiscount: ([Discount] Is Null)

You can now Group By this expression.