Calculated field..What the hecK?

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
 
K

Ken Snell

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]))
 
S

Steve Schapel

Peggy,

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