database search

[Guest]

how do i search all records with a particular field filled in?

 

[Guest]

Look at this link on "Use of the Where Clause in Microsoft Access"

http://www.databasedev.co.uk/using-where-clause.html

 

[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]