Iif formula format problem - Percent

Myproblem

New member
Local time
Today, 18:39
Joined
Mar 29, 2012
Messages
5
hello folks, my first question

I am new in Access and I recently figure out that calculation field can be worked out by Iif formula.
Formula in my case works fine, it does as I want:
Iif(Budget=0;"No BudgeT";Act/Budget)

But I would like to format these results (where there is some number, not No Budget) as Percent (%)
I tried to use field properties but I failed.

Is it possible at all? What I am missing?
thx
 
guys, seems I figure out: it should be Format(iif...;"Percent") and works fine

cheers
 

Users who are viewing this thread

Back
Top Bottom