Math error in calculated field

[nashgas]

I am trying to create a simple Query that takes one column and multiplies each item by .05
Culumn name [Amount]

I input the following

nz([Amount]*.05,0)



It appears to work on all amounts except for 80
it outputs .45 instead of 4

Am I doing something wrong or is there a better way to do this.

I tried changing it to .04 and it does the same thing except with 50 it changes to .25 instead of 2.5

If anyone has any ideas or suggestion to help a new access user would be greatly appritiated
Thanks in advance

[pbaldy]

Computers are pretty good at doing math. I can't imagine Access would make that mistake. Can you post the db here, or a representative sample?

I changed the title of your thread to something more meaningful to future users.

[John_G]

That looks suspiciously like a format problem, rather than the math. Do you have a Format set for that query field? If so, try deleting it and running the query.