I have a flag that is set to yes and would like to display in a text field the word contractor but am having problems setting up the formula. Can anyone help?
Use the flag to set a column of data
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
I got it to work
IIf([Flag10]=Yes, "Contractor"," ")