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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtracting multiple columns from another column 3
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
Group header makes report too long 4
set field data as control source of another field in a report 2
Report to calculate total spent by customers in a customer db 8
Excel Help to copy information from one row at a time to another sheet 1
Calculating group totals for multiple var's. 1
Report calculation 5

Back
Top