Table Data / Calculation query

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

Guest

I have imported data from Excel into a table, the fields are essentially all
numbers. However some of the cells where no value existed would have a zero,
others are blank.

When I did a calculation in a select query, (sum of 3 fields), the
calculation does not give me a result if one of the fields had a blank in it.

Do I need to adjust the table data if so, is there and easy way?
Is there a way to handle in the calculation
 
I have imported data from Excel into a table, the fields are essentially all
numbers. However some of the cells where no value existed would have a zero,
others are blank.

When I did a calculation in a select query, (sum of 3 fields), the
calculation does not give me a result if one of the fields had a blank in it.

Do I need to adjust the table data if so, is there and easy way?
Is there a way to handle in the calculation
Click to expand...

Look up the Nz() function in VBA Help.
In a query, use:
CalcField:Nz([Field1],0) + Nz([Field2],0) + etc.
 
Back
Top