Calculated field

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
 
J

John Vinson

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?
 
Top