Trouble with budget report

[Msstaves]

Hi all,

I'm having trouble with a budget report in access 2007. I've got a few reports and It sorts my budget numbers by account type (revenue, direct expense, indirect expense, etc). All these are entered as positive numbers in the tables. What I need in the report is a field to subtract the expenses from the revenues. I'm having a lot of trouble trying to use DSum functions to get this to work and haven't had success. Can anyone give me suggestions on how to do this?


Thanks.

 

[pbaldy]

Any number of ways, depending on the specifics of your situation. Since you mentioned DSum:

DSum("AmountField", "TableName", "AcctType = Income'")-DSum("AmountField", "TableName", "AcctType = 'Expense'")