Method 1:
Create a query with the calculated field and save.
Create another query, using the first one as an input "table" along with the
other table.
Method 2:
Switch you query to SQL View, and type the expression into the FROM clause
directly.
Either way, there seems to be a bug in JET such that it processes outer
joins on calculated fields as if they were inner joins.
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.
