0.Restrict data input by using a validation rule
Expressions for Numbers | ||
Comparison | Sample Expression | Description |
Equal to | = 42 | The value must be 42. |
Less than | <100 | The value must be less than 100. |
Less than or equal to | <=100 | The value must be less than or equal to 100. |
Greater than | > 0 | The value must be greater than 0. |
Greater than or equal to | >= 0 | The value must be greater than or equal to 0. |
Not equal to | <> 42 | The value can be anything except 42. |
Not 42 | ||
Greater than X and less than Y | >10 and <20 | The value must be greater than 10 and less than 20. 10 and 20 are not included. |
Between BRING TEXTBOOK TOMORROW | Between 0 and 100 | The value must be 0, 100, or somewhere in between. |
>=0 and <=100 |
Expressions for Dates and Times | ||
Comparison | Sample Expression | Description |
Less than | <#30/1/2012# | The date occurs before January 30, 2012. |
Greater than | >#30/1/2012# | The date occurs after January 30, 2012. |
Between | Between #1/10/2013# and #31/10/2013# | The date occurs on October 2010. |
Greater than the current date | >Date( ) | The date occurs today or after. |
Less than the current date | <Date( ) | The date occurs yesterday or before. |
Greater than the current date (and time) | >Now() | The date occurs today after the current time, or any day in the future. |
Less than the current date (and time) | <Now() | The date occurs today before the current time, or any day in the past. |
Note: You have to write Full date. |
Expressions for Text | ||
With text, validation lets you verify that a value starts with, ends with, or contains specific characters. You perform all these tasks with the Like operator, which compares text to a pattern. | ||
Sample Expression | Description | |
The asterisk (*) represents... | ||