Calculation on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to subtract one record from another
Each record may have a number of similar items- hence I want to calculate
"all of type A" minus "all type B"

Currently the info is on a table with all valus in the same column.- there
is another column which defines whether the record is type A or B

Any ideas?

Cheers
 
David

I'm not sure I'm visualizing your situation yet.

If a record can have "a number of similar items", how can you "subtract one
record from another"?

Unless maybe you don't mean "record" in the sense that it is used for
Access, where "record" is synonymous with "row" in a table (or query)...?

If you are asking about summing all values in a field when record type = A,
and all values when record type = B, then taking the difference, have you
looked into either the DSum() function or using "Totals" queries?
 
Back
Top