|
| 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
May 9th, 2006, 08:11 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Validation: Basic Problem from a new user
I have created a ticket system.
In one table I have the fields OAP, Child and Adult. No field is allowed to have a greater value (or equal) than 4 and collectivly they must be equal or less than four. I've tried a few validation methods but none have worked. Please help! 
|
|
#2
May 9th, 2006, 08:20 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Validation: Basic Problem from a new user
"Damo447" wrote: I have created a ticket system. In one table I have the fields OAP, Child and Adult. No field is allowed to have a greater value (or equal) than 4 and collectivly they must be equal or less than four. I've tried a few validation methods but none have worked. Please help!
|
|
#3
May 9th, 2006, 10:59 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Validation: Basic Problem from a new user
In a table-level validation rule, you cannot reference other columns. You'll
have to do this at the form level. Barry "Damo447" wrote: I have created a ticket system. In one table I have the fields OAP, Child and Adult. No field is allowed to have a greater value (or equal) than 4 and collectivly they must be equal or less than four. I've tried a few validation methods but none have worked. Please help!
|
|
#4
May 10th, 2006, 03:07 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Validation: Basic Problem from a new user
"Barry Gilbert" wrote in message
... In a table-level validation rule, you cannot reference other columns. You'll have to do this at the form level. Incorrect. In table design you cannot create a *field* validation rule that references other fields but you can create a *table* level validation rule that does. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#5
May 10th, 2006, 05:08 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Validation: Basic Problem from a new user
My mistake. Open the table in design view. Select ViewProperties. In the
Validation Rule property, enter: [oap]4 And [child]4 And [adult]4 And ([oap]+[child]+[adult]4) Barry "Rick Brandt" wrote: "Barry Gilbert" wrote in message ... In a table-level validation rule, you cannot reference other columns. You'll have to do this at the form level. Incorrect. In table design you cannot create a *field* validation rule that references other fields but you can create a *table* level validation rule that does. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| User Defined Style Problem - Where to post? | Dave M | New Users | 3 | January 5th, 2006 09:49 AM |
| Please help. Visual Basic problem | Nancy | New Users | 0 | October 25th, 2005 03:30 PM |
| Corrupt Windows Componenet, or Outlook Problem? | BPC23 com> | General Discussion | 0 | May 27th, 2005 06:08 PM |
| Validation of User Data Entry of Excel Range Address | Rick Grieser | Worksheet Functions | 1 | September 5th, 2004 09:57 PM |
| Columns and layout problems | Phil | Setting Up & Running Reports | 4 | August 18th, 2004 01:34 PM |
Linear Mode
