Changing a join breaks the DLOOKUP

[JamesMF82]

Hi,

Bit of a strange question / problem. I am using a Dlookup between two queries. Everything runs fine is I leave the join as option 1: only include rows where the joined fields in both tables are equal. But if I change it to number 3 Include ALL records in right table in left it returns a syntax error on the query.

Any ideas? I can run the same query with same relationships of another table and it is fine! No idea!

 

[plog]

Its a bit of a misleading question:

I am using a Dlookup between two queries

After that statement you use phrases that have nothing to do with a Dlookup, but instead are terms used with a query. So what are you having trouble with--a Dlookup or building a query?

Post whatever code you are having trouble with.

 

[CJ_London]

if your dlookup criteria is based on a field or fields from the 'left' table i.e. the one that is not all returned then you are trying to pass a null value which can cause the error.