Round Down in Query

[Guest]

I would like to use and expression to calclulate a percent. Here is the exp.
Expr1: Round([Column 1]/[Column2],2)

I am rounding to 2 because it is a percent, however I want to round down
such that 97.8% is displayed as 97%

Can anyone help??

 

[Guest]

Expr1: Int(Round([Column 1]/[Column2],2))

 

[Guest]

Dennis -

When I change the expression, formula result is 0% for this column???

Expr1: Int(Round([Column 1]/[Column2],2))

I would like to use and expression to calclulate a percent. Here is the exp.
Expr1: Round([Column 1]/[Column2],2)

I am rounding to 2 because it is a percent, however I want to round down
such that 97.8% is displayed as 97%

Can anyone help??

 

[Guest]

If you want the outcome to be with no decimal places, then just use
Int([Column 1]/[Column2])

If you want to have 2 decimal places but round the decimal
from 9.277 to 9.27 instead of 9.28, then

Int(([Column 1]/[Column2])*100)/100
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Expr1: Int(Round([Column 1]/[Column2],2))

I would like to use and expression to calclulate a percent. Here is the exp.
Expr1: Round([Column 1]/[Column2],2)

I am rounding to 2 because it is a percent, however I want to round down
such that 97.8% is displayed as 97%

Can anyone help??

 

[Guest]

I have a similar problem. I am trying to get Access to round down dollar
amounts returned in a query. The dollar amounts are entered by users and I
need to query all amounts in a particular time period and round down to the
nearest dollar (i.e. $97.68 = $97).

I tried the expression: Int([Lumpmisc Credit Amt1])
However, Access then asks me to enter a value into a popup box for the field
"Lumpmisc Credit Amt1".

Any help is much appreciated!

If you want the outcome to be with no decimal places, then just use
Int([Column 1]/[Column2])

If you want to have 2 decimal places but round the decimal
from 9.277 to 9.27 instead of 9.28, then

Int(([Column 1]/[Column2])*100)/100
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Expr1: Int(Round([Column 1]/[Column2],2))

I would like to use and expression to calclulate a percent. Here is the exp.
Expr1: Round([Column 1]/[Column2],2)

I am rounding to 2 because it is a percent, however I want to round down
such that 97.8% is displayed as 97%

Can anyone help??

 

[Guest]

Is "Lumpmisc Credit Amt1" the name of the field in the table that you are
trying to round down?

If this field nae doesn't exist, then the query will assume that "Lumpmisc
Credit Amt1" is a parameter, and this is why you are prompt to enter the
value.

Check the fieldName

--
Good Luck
BS"D

I have a similar problem. I am trying to get Access to round down dollar
amounts returned in a query. The dollar amounts are entered by users and I
need to query all amounts in a particular time period and round down to the
nearest dollar (i.e. $97.68 = $97).

I tried the expression: Int([Lumpmisc Credit Amt1])
However, Access then asks me to enter a value into a popup box for the field
"Lumpmisc Credit Amt1".

Any help is much appreciated!

If you want the outcome to be with no decimal places, then just use
Int([Column 1]/[Column2])

If you want to have 2 decimal places but round the decimal
from 9.277 to 9.27 instead of 9.28, then

Int(([Column 1]/[Column2])*100)/100
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Expr1: Int(Round([Column 1]/[Column2],2))

:

I would like to use and expression to calclulate a percent. Here is the exp.
Expr1: Round([Column 1]/[Column2],2)

I am rounding to 2 because it is a percent, however I want to round down
such that 97.8% is displayed as 97%

Can anyone help??

 

[Guest]

Yes "Lumpmisc Credit Amt1" is the name of the field. I even copied and
pasted to ensure that I was using the correct spelling and still got the
prompt.

Should I try to use a calculated field for this or would it be better to use
the field and then enter the calculation as a criteria?

Is "Lumpmisc Credit Amt1" the name of the field in the table that you are
trying to round down?

If this field nae doesn't exist, then the query will assume that "Lumpmisc
Credit Amt1" is a parameter, and this is why you are prompt to enter the
value.

Check the fieldName

--
Good Luck
BS"D

I have a similar problem. I am trying to get Access to round down dollar
amounts returned in a query. The dollar amounts are entered by users and I
need to query all amounts in a particular time period and round down to the
nearest dollar (i.e. $97.68 = $97).

I tried the expression: Int([Lumpmisc Credit Amt1])
However, Access then asks me to enter a value into a popup box for the field
"Lumpmisc Credit Amt1".

Any help is much appreciated!

If you want the outcome to be with no decimal places, then just use
Int([Column 1]/[Column2])

If you want to have 2 decimal places but round the decimal
from 9.277 to 9.27 instead of 9.28, then

Int(([Column 1]/[Column2])*100)/100
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

Expr1: Int(Round([Column 1]/[Column2],2))

:

I would like to use and expression to calclulate a percent. Here is the exp.
Expr1: Round([Column 1]/[Column2],2)

I am rounding to 2 because it is a percent, however I want to round down
such that 97.8% is displayed as 97%

Can anyone help??