Round Up In Queries

[Jason Lepack]

Use Allen Browne's method.

Allen Browne Said:
In a query, type this expression into the Field row:
- Int( - [MyField])
replacing MyField with the name of your field.

1.01 will round up to 2, and -1.01 will round up to -1.
Use Fix() instead of Int() if you want a different result for
negatives.

If you want to write the values back to your table, change the query
into an
Update query (Update on Query menu.)
<end quote>

Cheers,
Jason Lepack