>> AR Invoices and Cash Receipts
Just a followup on an old thread637-1720718
I finally discovered a limitation in the ODBC driver being used.
Documentation states.... limit of one left outer join per query.
Once I realized this restriction I was able to get the results I needed.
Now use sub-queries in Access and sub-reports in Crystal when I need multiple open joins.
Very slow but... at least it works.
New to me, I'd never heard of a restriction like this before.
Bruce O
Just a followup on an old thread637-1720718
I finally discovered a limitation in the ODBC driver being used.
Documentation states.... limit of one left outer join per query.
Once I realized this restriction I was able to get the results I needed.
Now use sub-queries in Access and sub-reports in Crystal when I need multiple open joins.
Very slow but... at least it works.
New to me, I'd never heard of a restriction like this before.
Bruce O