I'm using a qry as the recordset for my SQL and when I try and add another table to the query I receieve this message, which I don't understand. How can I add the table/fields to the query, or join the query into the recordset?
Run-Time error 3258
The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement.
Thanks in advance for your help,
KerryL
Run-Time error 3258
The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement.
Thanks in advance for your help,
KerryL
