Joining MS Access and SQL Tables on null

[Hemish]

Hi,

I am try to join 2 tables together.

1 table is a SQL table and the other table is a MS Access Table.

The problem i am having is on the sql table sometimes the field is either null or " " or "" so in my MS Access table i have tried joining when the field is null but does not bring out any results.

I even created another query for the SQL table and trimmed the field then on another query tried joining but same problems.

Does anyone know how to go about this.

Thanks

 

[jdraw]

Not enough info.

Please show the query SQL and tell us more about the tables and fields involved; and what exactly you are trying to do.