Problem with calculations and multiple AND's in criteria

Problem with calculations and multiple AND's in criteria

Post by John Vinso » Fri, 02 Jul 2004 08:16:00


On Wed, 30 Jun 2004 13:36:01 -0700, "P CORREA"



Try

(>=[Forms]![Switchboard]![MIN SQ FT FIELD] OR
[Forms]![Switchboard]![MIN SQ FT FIELD] IS NULL)
And
(<=[Forms]![Switchboard]![MAX SQ FT FIELD] OR
[Forms]![Switchboard]![MAX SQ FT FIELD] IS NULL)

This will show all records greater than MIN if you leave MAX blank;
all records less than MAX if you leave MIN blank; all records in
between if you fill in both; and all records in the table if you leave
both blank.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://www.yqcomputer.com/