What you can do is two things: 1. You can change the query property in the Design View of the Query Builder to Currency. You do that by right-clicking on the field you want to change and choice Properties and then select Format from the drop down box and pick Currency.
2. You can do this also, you can create a new field in the Query Builder and use the ROUND function in Access to round up the number. This is the one I use all the time. Example: In the Query Builder I would make a new field called SalesTaxRound:ROUND([SalesTax],2) and that's it...What that will do is Round off your number 2 places... I hope you understand this and enjoy MS Access for Life...Bye now! ~genebat~ [Non-text portions of this message have been removed]
