Calculated field

  • Thread starter Thread starter MJM
  • Start date Start date
M

MJM

Trying to sum two fields. "Subtotal"= 15 and "SalesTaxTotal"= 12.45
When I created the calculation field the result that I get is "151245" or
something similar. What am I missing?

Thanks
 
Trying to sum two fields. "Subtotal"= 15 and "SalesTaxTotal"= 12.45
When I created the calculation field the result that I get is "151245" or
something similar. What am I missing?

Thanks
Click to expand...

The fields are either Text fields or they're some how being translated
to text (the Format() function converts a number to a text string, for
example). Could you post the actual SQL of your query?
 
Back
Top