Access 2000 with DWUD 4.0. Typically Search window (nothing fancy with list menus to allow the user to select search criteria). I have four list menus for search criteria for the user. The SQL uses the "LIKE" operator with the default of "%" as a wildcard. The variable is passed from the search screen to the results screen. The SQL looks at a view or query in Access.

Where my problem exists is when the data field is "Null". These records are not picked up by the SQL / wildcard. Any suggestions or Hits as to what I am missing.

Wm. Kent Steelman