Do a sum from tree different fields

  • Thread starter Thread starter Frank Dubuc
  • Start date Start date
F

Frank Dubuc

Hi, (I have already posted something about this but now
it's more detailled)

I made a query that do the sum of 12 different fields.
Each of these fields are regroup by 3 (4 groups). I want
to put this in a report but I need another data.

I need for each of these groups, the number of records
where for the 3 corresponding fields at least one is higher
than zero.

All the fields are numeric. Each record for each field are
summed in another field of the query.

I want to get to sum of each record that has at least one
field out of 3 that is over zero.

I have though of a solution but it's not elegant. If I
could use more than one query in my report I would be able
to show what I want in my report:

First group:
number of records with at least one over zero: __ (from a
query X)
number of A : __ (from a query Y)
number of B : __ (from a query Y)
number of C : __ (from a query Y)

Second group:
number of records with at least one over zero: __ (from a
query Z)
number of A : __ (from a query Y)
number of B : __ (from a query Y)
number of C : __ (from a query Y)

And so on ...
 
Frank,
Type or paste some sample records into a post and then the expected display
results. This is a real unusual request and some better visuals would help.
 
Back
Top