fixed function

A

aaron.kempf

so im going thru the help.. trying to troubleshoot this problem..

i woudn't normally use access.. since im a sql guy.. but im in this
Oracle/IBM shop and my choices are excel and access.. pretty much a
no-brainer.

so i have some simple decimal place data.. im just confused

FIXED
Rounds a number to the specified number of decimals, formats the number
in decimal format using a period and commas, and returns the result as
text.


ok. so this is a NUMBER. I want to show it with 4 decimal places.

WHY WOULD THE RESULT BE TEXT?

IT'S A NUMBER, ISNT IT?
 
D

Dirk Goldgar

so im going thru the help.. trying to troubleshoot this problem..

i woudn't normally use access.. since im a sql guy.. but im in this
Oracle/IBM shop and my choices are excel and access.. pretty much a
no-brainer.

so i have some simple decimal place data.. im just confused

FIXED
Rounds a number to the specified number of decimals, formats the
number in decimal format using a period and commas, and returns the
result as text.


ok. so this is a NUMBER. I want to show it with 4 decimal places.

WHY WOULD THE RESULT BE TEXT?

IT'S A NUMBER, ISNT IT?
Click to expand...

What "FIXED" function are you talking about? There's no builtin
function named that in Access VBA. There's a Fix() function, but it
doesn't behave the way you describe. I wonder if that's one of those
Excel functions that often show up in Access help to confuse the unwary.
 
Top