Access won't add my field's with zeros

  • Thread starter Thread starter chadt74
  • Start date Start date
C

chadt74

Hey guys sorry for the simple questions but I'm starting to use Access
again after quite a few years away and I was never very good to begin
with!

Anyway I have three fields in a data base I want to add

Amount
AmountPaid
CreditIssued

So I have a Query and in the 4th field I have AmountOS:
[Amount]-[AmountPaid]+[CreditIssued]

And it will only add the records with an amount, amount paid and a
credit issued.

In my database I have the default value for all three fields listed as
zero but they will not show up on the data base, just blank (I
imported the table from excel).

Just wondering if anyone can give me an answer to how I can do this
and have it add all of the cells even if they are zero or have no
value?

Thanks in advance.

Chad
 
try

Nz([Amount], 0)-Nz([AmountPaid], 0)+Nz([CreditIssued], 0)

btw, i was wondering why "credit issued" increases the total amount rather
than decreasing it. just curious.

hth
 
Back
Top