I have searched the forum for a couple of days and dont seem to be able to find the solution to my problem. Sorry if I have missed it. Anyway...
On my form I have an option group for Accepting or Rejecting a request. The two options are saved as 1 and 2 in the table. I know that I can use the Choose Function to change the 1 and 2 to show Accept and Reject on my report
=Choose([Decision],"Accept","Reject")
but the problem is that not all requests have a decision against them, some are still blank, so the Choose function errors. I have tried Switch and Iif but both error can any one help? Please? Thank you.
On my form I have an option group for Accepting or Rejecting a request. The two options are saved as 1 and 2 in the table. I know that I can use the Choose Function to change the 1 and 2 to show Accept and Reject on my report
=Choose([Decision],"Accept","Reject")
but the problem is that not all requests have a decision against them, some are still blank, so the Choose function errors. I have tried Switch and Iif but both error can any one help? Please? Thank you.
