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.
 

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

IIF statement failing 3
Past Due Expression 1
IIF statement 6
Calucation in query 2
Query & calculated field 1
Union 2
Limit the results from a calculated field in a query 7
Two Identical Queries...Different outcome 3

Back
Top