Calculation Problems in Access 2003

[BuckBaxter]

I'm having trouble getting results in the right format. I want to multiply UnitPrice by Quantity with the result in ExtendedPrice. The ExtendedPrice result winds up with one too many digits after the decimal point that causes SubTotal to be off by a cent or two. I've changed data types on all fields and I seem to be getting the best results with the text data type. However, I'm still getting three digits after the decimal in ExtendedPrice. I've tried setting the decimal point value to 2 but it has no effect. Any suggestions?

[r035198x]

I'm having trouble getting results in the right format. I want to multiply UnitPrice by Quantity with the result in ExtendedPrice. The ExtendedPrice result winds up with one too many digits after the decimal point that causes SubTotal to be off by a cent or two. I've changed data types on all fields and I seem to be getting the best results with the text data type. However, I'm still getting three digits after the decimal in ExtendedPrice. I've tried setting the decimal point value to 2 but it has no effect. Any suggestions?

Only one post is enough for people to help you. Double posting puts some people off.

[BuckBaxter]

The double post was an accident.....Oh , by the way, thanks for the help Dickweed.

[darren1317]

The double post was an accident.....Oh , by the way, thanks for the help Dickweed.

Oh dear, I think you've blown your chances of getting help now!

[dima69]

It's really quite simple - you should use Round function within your Extended price calculation:

=Round([Price]*[Quant],2)

And also within the total:

=Sum(Round([Price]*[Quant],2))

[r035198x]

The double post was an accident.....Oh , by the way, thanks for the help Dickweed.

That is not neccessary