How do you turn off automatic rounding in a query IIf statement?

  • Thread starter Thread starter JMalecha
  • Start date Start date
J

JMalecha

I am using an IIf statment in my query and the result is rounding the numbers
instead of displaying the decimal places. I have tried changing the
properties to show one decimal place, but it is still rounding.
 
Where did you change the decimals? You should change this in the table design
of it is one of the operators. If it's a calculation answer try putting the
iif in a Cdbl function which might give it the necessary decimals. Also
rightclik the field in the query field and place the decimals there also
(format)

So the statement could look something like this:

iif(testhere="test";"test";cdbl(calculationfieldhere))

hth
 
I am using an IIf statment in my query and the result is rounding the numbers
instead of displaying the decimal places. I have tried changing the
properties to show one decimal place, but it is still rounding.
Click to expand...

It would help a bit if you would post the actual SQL view of the query. My
guess is that you're using a table field with the default Long Integer
datatype; integers are by definition whole numbers.
 
Back
Top