J
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
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