#error from formating the other columns

[mike02]

Hey,



I have a query with an expression to total the rows. Worked great, until I tried formating it to % by using the format function...Format(expresssion, "Percent")

The issue now is It leaves #error.

the reason for the Format function is that it doesnt format by using the properties menu.

Thanks,

[JoeM]

Where exactly are you doing this total? On a Form or Report?
Note that the results of a FORMAT function is a string, so you cannot perform any mathematical function on it.
You CAN format the results using the Properties menu. Under the Format Property, there is a "Percent" option.
If you cannot get it to work, please provide an example (maybe you are trying to format integers instead of decimals?).

[mike02]

looking at the format function being a string, my guess would be that the Nz function is as well then? For my expression to work I use the NZ() to leave a value of zero if Null on my table. do you know how I would be able to get around this? personally It doesnt matter if my query Is decimals, but I would like my report to be Percent. Now, I have tried changing the text box properties to percent yet it ignores that request.

[JoeM]

You can coerce the results from NZ to be numeric by adding zero to the result:
NZ(..,0) + 0

Now, I have tried changing the text box properties to percent yet it ignores that request

What is the format of the field that is the Source of your Text Box?
If the Source is a formula, what is that formula?

[mike02]

awesome! coercing access to make it a number worked great! thanks for the advice!

[JoeM]

Great! Glad it worked out for you.