Null Value in Linking Field

[Guest]

I am having trouble hooking two tables together because one of the tables can
have null values in the field that I would like to join on. Is there a way
in SQL that if a value is null that join is not exercised?

 

[John Vinson]

I am having trouble hooking two tables together because one of the tables can
have null values in the field that I would like to join on. Is there a way
in SQL that if a value is null that join is not exercised?

ummm... if a value is null, the join ISN'T execised.

Could you post the SQL of the query, and any error messages (or the
undesired outcome) that you're getting??

John W. Vinson[MVP]

 

[Guest]

John thanks for you help. I figured out a way the user could modify some
values to get around the problem we were having.

Thanks again.