I have a report that lists sales by Type in the Detail Section and is
grouped by Customer. If a customer has two related types of sales, I want to
report the sum of these sales together with their individual amounts.   For
example:

Customer: ACME
    sporting goods    $12

    women    $10
    men    $5
    Total clothing $15

    accessories    $5

Thus, if sales Type for any customer includes both women and men, the report
will include a line reporting the individual amounts and the total.

Each customer will only have one type 'women' and one type 'men' sale.  I
need a way to report the sum of these two types if both of these types are
present in the detail section of the report.

I tried creating a group footer for Customer and using logical operators
with a summation but I can't get anything to work.

Thanks for any insights,
Dave

   I'm sure there's a better forum for this question, but for this
time, here goes:
   This one should be fairly easy.  Create a section header/footer
that's linked to the men/women field, and create a calculated field
whose ControlSource property is "=Sum([FieldInDetail])".  This
should give you the summation you're looking for.

Regards,
Daniel.