Hi Everyone
Is it possible to use something like this in the default value for a field [rank] in a table
= if([firstname] ="john", 8,9)
ie when [firstname] for a new record is entered as john, the default field value for [rank] in the new record is set to 8 otherwise it is 9.
Cant seem to get it to work - do I need to be using iif - or - me.[firstname] or me![firstname]
Im hoping it is just a syntax problem . . . .
Is it possible to use something like this in the default value for a field [rank] in a table
= if([firstname] ="john", 8,9)
ie when [firstname] for a new record is entered as john, the default field value for [rank] in the new record is set to 8 otherwise it is 9.
Cant seem to get it to work - do I need to be using iif - or - me.[firstname] or me![firstname]
Im hoping it is just a syntax problem . . . .