Expression Builder Missing Expressions

A

AndreiK

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
 
L

Lynn Trapp

Those functions can't be used in table validation rules, so you won't find
them there.
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Compile error in table level validation expression " after format 0
Get unique values in expression builder 0
A table validation rule question. 6
Formule for Expression Builder 3
Validation rule for email field 5
Text function names ending in "$" 2
Table Names not showing in the Expression Builder 2
multiple validation rules 3

Top