IIf Function

  • Thread starter Thread starter Dan Dan the OTTR Man
  • Start date Start date
D

Dan Dan the OTTR Man

I have an IIf function that, when the condition evaluates as false, it
divides one value from a table by another. I do this so that the
query will display a null instead of and #ERROR. The problem is that
it displays the numbers with no decimals. I'm not sure what's wrong
with it. Has anybody run across this before?
 
Dan,
Is this just a calculated control, or do you update some bound control
with the results of a calculation?:
Care to share your code with us?

If you're updating a bound control, what num type and format is the
bound field in your table?
It should be Single or Double. Integer, Byte, and Long Integer can not
accept decimal values.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top