decimal problem

[jason2885]

Is there anyway in a query or a form to set the amount of decimal places on a number or change it to currency. In one query im dividing a price by a mileage and I get a really long string of number and I need to make it just be two decimals.

Any ideas.

 

[boblarson]

If you go to the format property of the text box, you can select the drop down that says CURRENCY.

 

[jason2885]

Thanks that did the trick.

 

[boblarson]

No problem