Calculated Fields

[hollyann]

I have created a database and the final 8 expressions in the database need to round to the nearest fifty cents (I created all the calculated expressions in a query to determine client income eligibilty).

 

[DougP]

Do you have a question???????

 

[famousb]

i'm assuming that you want to know how to get your fields to round to the nearest $.50.&nbsp;&nbsp;i'm also going to go out on a limb and assume you want them to all round up, as oppossed to actually rounding to the nearest .50.<br><br>It would be much easier to simply round to the nearest $.10 or to the nearest $1, this would be accomplished by simply limiting the decimal places to either 1 or 0, respectively. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>