Key Field NULL

[guest]

I am having trouble understanding this myself, so forgive me if I am unclear:

I have two tables, my criteria for a query on these tables is as follows:
IF UD2 <> 0 AND VENDORID=NULL return these values.

My problem being is that VENDORID is a key field and in a separate table from UD2. If VENDORID is NULL then the query won't return anything.

How can I say if the 'table' is NULL return any UD2 <> 0 results?

Does this sound the right way to do things?

If I have not explained this at all well then I apologise.
Thanks for any assistance.

 

[bat17]

I am not really sure what you are doing but I suspect that you need to set up your query with the join properties for the tables set so that you return all records for the table with UD2 and only matching records for the table with VENDORID


HTH

Peter