formula in access 2007

  • Thread starter Thread starter pat
  • Start date Start date
P

pat

I have a report from Access 2002 and did a calculation of
=(Sum([ABSTRACT])+Sum([BILLBOARD])+Sum([TBE])+Sum([BLDG_BUY])+Sum([DAMAGES])+Sum([FENCE])+Sum([IMP])+Sum([INCIDCOMP])+Sum([LAND])+Sum([PDE])+Sum([RELOCATION])+Sum([SUBORDINAT])+Sum([TCE])+Sum([TCM])+Sum([TDM])+Sum([TDRAE])+Sum([TDRIE])+Sum([TDTE])+Sum([TSE])+Sum([TSPE])-Sum([tbe])-Sum([credit])-Sum([faris_amt]))

Now in Access 2007 this calculation appears with ( ) before and after the
number. and it is not a negative number. I cannot make the ( ) go away.
Thanks for your help.
 
Pat

The formula you provided reminds me a lot of a ... spreadsheet!

I'm not sure why the formatting (maybe that's a clue) of your answer has the
parentheses.

But I would suggest you take another look at whether you are attempting to
use Access as if it were a spreadsheet-on-steroids...

(And if there's a Null value for any of those terms, the expression will
evaluate to a Null overall...)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top