Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a calculated field named "Estimated Total" which should give the
total of a number of fields added together. However, if one of them is null,
the calculated field is not returning the total value.

Please see the syntax below and provide support.

EstTotal: [Excess_Baggage]+[Shipment]+[Airport_Tax]

Thanks.
 
Hello,

I have a calculated field named "Estimated Total" which should give the
total of a number of fields added together. However, if one of them is null,
the calculated field is not returning the total value.

Please see the syntax below and provide support.

EstTotal: [Excess_Baggage]+[Shipment]+[Airport_Tax]

Thanks.
Click to expand...

Look up the Nz function in VBA help.

EstTotal: Nz([Excess_Baggage]) + Nz([Shipment]) + Nz([Airport_Tax])
 

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

Adding the value of two fields when value is null 4
Access Updating inventory levels 0
How to grand total expression value fields in query 1
calculating running totals 2
calculating currency formatted fields 7
Calculation does not show minus values 2
Aggregate calculations on calculated query fields? 6
IIf statement in Access 2003 query 9

Back
Top