outer joins not picking up null records

  • Thread starter Thread starter phil
  • Start date Start date
P

phil

in right side of left join, records are not returning with those w/o rt
table record.

seems to be occasional.

Does anyone know what causes this and/or how to fix it.

ms2000, win98se, jet 4.0.
 
Phil:

There could be various issues here, but I would guess that the field upon
which you are testing for null is a text field that is set in its table to
allow zero length strings. As a result the field is not truely null; it
may contain a ZLS (which can happen as an example when a user deletes a
field value in a form, which in my experience often turns the field value
into a ZLS rather than a null if allow zero length strings is set to true.)
 
Back
Top