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...