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
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