Calculated field..What the hecK?

  • Thread starter Thread starter pEGGY
  • Start date Start date
P

pEGGY

Why does this in a calculated field in a query
Balance:([ServCharge]+[PastDue])

If ServCharge is 2 and past due is 10 it returns 210
instead of 12
 
My guress is that ServCharge and PastDue fields are both formatted as text
field, not numeric fields. Thus, ACCESS is concatenating the string values,
not adding the numeric values.

Unless you can change the format of the fields to numeric, use an expression
similar to this:
Balance:(Val([ServCharge]) + Val([PastDue]))
 
Peggy,

Looks like at least one of the fields ServCharge or PastDue is being
trated as a text data type.
 
Back
Top