Creating "Smart" validation rule.

From: "Alex.Sh" <greeen@xxxxxxxxx>
Date: Thu, 28 Jun 2007 07:48:10 -0700

How can i do something like this:

i have a form with

A percentage : ______
B percentage: ______
C percentage: ______

I want that the sum of these 3 fields *will never* be more than 100
(so user won't be even able to fill it).

how can i do something like that? i don't care if it's on the form/
query/table level.

Thank you for you help.
Alex.

.

Follow-Ups:
- Re: Creating "Smart" validation rule.
  - From: paii, Ron

Prev by Date: Citrix occasionally corrupting row of data.
Next by Date: Re: Running Totals Query Access97
Previous by thread: Citrix occasionally corrupting row of data.
Next by thread: Re: Creating "Smart" validation rule.
Index(es):
- Date
- Thread