Rounding Up

[Guest]

I have a query where I want the values rounded to a whole number. If its 1.5 -2 and .25 -1. How cna I accomplish this.

 

[Brian Camire]

You might use an expression like:

-Int(-[Value])

I have a query where I want the values rounded to a whole number. If its

1.5 -2 and .25 -1. How cna I accomplish this.

 

[dean]

where would you use this formula?

-----Original Message-----
You might use an expression like:

-Int(-[Value])

I have a query where I want the values rounded to a

whole number. If its
1.5 -2 and .25 -1. How cna I accomplish this.


.

 

[Brian Camire]

In your query, you would enter this expression in the Field row of an empty
column of the query design grid.

Substitute "[Value]" with the name of the field whose value you want to
round.

So, for example, if your query was based on a table named "Your Table" and
had a field named "Your Field" that you wanted to round, and you wanted the
field containing the rounded value in the query results to be named "Your
Rounded Field", you would enter the following expresssion in the Field row
of an empty column of the query design grid:

Your Rounded Field: -Int(-[Your Table].[Your Field])

where would you use this formula?

-----Original Message-----
You might use an expression like:

-Int(-[Value])

I have a query where I want the values rounded to a

whole number. If its
1.5 -2 and .25 -1. How cna I accomplish this.


.