Checking for a NON null value

[thomas49th]

Hi, how do I check through each record in a table to see if the field "Notes" is NOT a null value

Thx

 

[brunces]

Thomas,

Have you tried creating a query and putting the words "Is Not Null" (without quotes) under the field "Notes"? It should work. Unless you need something different (via VBA or something).

Hope it helps. Hugs,

Bruce

 

[GohDiamond]

Create a query based on the table. Make sure you include the "notes" field and any other fields you need to identify the record.
in the criteria area of the Query under Notes type: IS NOT NULL

In SQL try:

Select "*" FROM

WHERE ((Notes) IS Not Null)