Null Where Condition 1

[jimb0ne]

I'm having a problem, I have a table which has several fields. Some of these fields have less items listed in them then other fields. What I am trying to do is search within a field in the table for a Null value, but I don't know what the syntax for null is in SQL. Example:

rs.FindFirst "FieldName = NULL"

but the above does not work. the NoMatch value of the recordset is still true even if the field does contain null values.

Thanks,
Jimb0ne

 

[Sandman83]

Have you tried

rs.FindFirst "FieldName = """

 

[jimb0ne]

you can't really do a blank string with using chr(34) and I tried putting 2 of those together but it still returns nomatch as true.

 

[RoyVidar]

Hi!

Not sure, but could you try:

[tt]rs.FindFirst "FieldName is null"[/tt]

Roy-Vidar

 

[jimb0ne]

wtg Roy, good thinkin' y0.