Calculations in a query coming up incorrect.

M

Melissa

Some of my calculations in my query are coming up incorrect. For example,
$868.26*198=$171,915.48. But it is coming up $171,916.47 instead. This is
happening with a couple fields in this query. Everything else is right on.
Any suggestions on why this may be happening??
 
R

Rick B

Are you sure your fields contain the values you indicated? Is the $868.26
coming from a filed that could be truncated? How about the 198?

What type of fields are these?

I'm betting you have a rounding issue here.
 
M

Melissa

Rick B said:
Are you sure your fields contain the values you indicated? Is the $868.26
coming from a filed that could be truncated? How about the 198?

What type of fields are these?

I'm betting you have a rounding issue here.





The 868.26 field is set to currency; the 198 is a number field, with the field size set to single and the format set as a general number; the 171,915.48 is also set to currency.
Click to expand...
 
M

Melissa

Rick B said:
Are you sure your fields contain the values you indicated? Is the $868.26
coming from a filed that could be truncated? How about the 198?

What type of fields are these?

I'm betting you have a rounding issue here.





The 868.26 field is set to currency; the 198 is a number field, with the field size set to single and the format set as a general number; the 171,915.48 is also set to currency.
Click to expand...
 
Top