2003 LEFT OUTER JOIN gives #Error

  • Thread starter Thread starter Michael Thornton
  • Start date Start date
M

Michael Thornton

On certain tables the missing record returns #Error instead of NULL.
Any ideas ?
Thanks
 
On certain tables the missing record returns #Error instead of NULL.
Any ideas ?
Thanks
Click to expand...

Local tables? or linked? Are you certain that the linking fields are
of the same datatype and size?

John W. Vinson[MVP]
(no longer chatting for now)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outer Join 1
Left outer join 10
To give inner join and Left outer Join 3
Access outer joins? 4
Nesting outer joins with ODBC and Access 2003 3
Can't outer join or append. 2
outer join 10
Outer Join and a two step query 1

Back
Top