Calculated column in query (1 Viewer)

[moi]

Good day sirs,
Pls i need help, i wanted to add calculated column to my query, adding 3 columns.. What i have is "totalpayments[reservation]+[downpayment]
+[amountpaid])" . But it give me blank.. Is this not working in access?.

 

[MajP]

If any value is null then it will become null. You might have to wrap each part
totalpayments: nz([reservation],0) +nz([downpayment],0) + nz([amountPaid],0)

 

[moi]

If any value is null then it will become null. You might have to wrap each part
totalpayments: nz([reservation],0) +nz([downpayment],0) + nz([amountPaid],0)

Thank Sir MajP
Its working, but it gives me a popup enter parameter value "Totalpayments. Can you pls take a look, where is this parameter came from..

Also how can i format into currency the result.

Many thanks sir.

 

[Minty]

Are you using totalpayments in another calculation in the same query?

 

[moi]

If any value is null then it will become null. You might have to wrap each part
totalpayments: nz([reservation],0) +nz([downpayment],0) + nz([amountPaid],0

Are you using totalpayments in another calculation in the same query?

Yes, it is use to get the balance (totalcontractprice) - (totalpayments).

 

[ebs17]

Show the ENTIRE query, preferably the SQL statement from the SQL view, in text form as code.

 

[CJ_London]

try

due: totalcontractprice-([reservation]+[downpayment])

if totalcontractprice is also calculated, use the calculation aka totalpayments

 

[moi]

try

due: totalcontractprice-([reservation]+[downpayment])

if totalcontractprice is also calculated, use the calculation aka totalpayments

totalcontractprice is not calculated.. it is entered

 

[moi]

totalcontractprice is not calculated.. it is entered

I think it is working..many thanks sir.