Information générale
Titre:
Multiple IIFs in Grid Column Control Source
In a Grid I have 1 column which I would like to display the contents of a field "status" from table "events" as following:
If status=1
display 'OK'
If status=2
display 'Cancelled'
If status=3
display 'Did Not Attend'
etc etc
In the control source of the column I have entered:
iif(events.status=1,"OK," "), iif (events.status=2,"Cancelled"," "), iif(events.status=3,"Did Not Attend," ")
but I get an error message "The Data Source for This Object must be a Variable Object"
What am I doing wrong?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement