database search

J

John W. Vinson

On Mon, 15 Oct 2007 02:18:01 -0700, sara conroy <sara
how do i search all records with a particular field filled in?

A criterion of

IS NOT NULL

on the field will find all records with anything in the field. Warning: if you
have a Text field with "Allow Zero Length" set to yes, an empty string "" is
not NULL and will be found.

John W. Vinson [MVP]
 
Top