If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Expression Builder Missing Expressions
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 |
#2
|
|||
|
|||
Those functions can't be used in table validation rules, so you won't find
them there. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "AndreiK" wrote in message news 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 |
#3
|
|||
|
|||
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. -- Duane Hookom MS Access MVP -- "AndreiK" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using expression builder in default value | Copwriter | New Users | 8 | September 21st, 2004 09:42 PM |
Expression Builder | [email protected] | Setting Up & Running Reports | 1 | September 11th, 2004 07:51 PM |
non-functional Expression Builder | Larry | Running & Setting Up Queries | 0 | August 26th, 2004 03:00 PM |
expression not working in report - help! | Melanie | Setting Up & Running Reports | 2 | August 20th, 2004 03:42 PM |
Displaying Numbers Missing In A Sequence | Rick D | Worksheet Functions | 7 | November 25th, 2003 07:32 PM |