Expression Builder Missing Expressions

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

Guest

Hi,
I am trying to locate the expressions: IIF, Count, Sum, in the Expression
Builder window opened through Validation Rule in TableDesign. (Access 2002 -
Windows XP)
Can you please indicate where are the above expressions located ?
Thanks,
AndreiK
 
Those functions can't be used in table validation rules, so you won't find
them there.
 
You can try to just type them in. Keep in mind the validation of a field is
very limited. I would expect that Count, Sum,... are not going to be
supported.

The validation in a form often allows greater functionality.
 
Back
Top