Error in Switch or IIF expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=Switch(Not IsNull([LastUsed]),1,IsNull([LastUsed]),[%Completed]
Above is the line of cod
%Completed is a Number with a field size of singl
when the second condition is true I get an error if I use [%completed] but not if I use another field that happens to be an intege
I have tried converting the field but since I need a .60 if I want to display 60% and Single and Double Field sizes are not working I am at a loss
%Completed has a default value of 0 so something will always display

Can anyone help

BTW if I do not put the switch statement or even a IIF statement aroun the %completed it displays fine

Thanks for any assistance available.
 
Thanks for checking i

I continued to peruse the boards and found I had a duplicate naming issue

Have a great day
 
Back
Top