Join on calculated field

  • Thread starter Thread starter Arthur
  • Start date Start date
Yes, JET supports joins on calculated fields.

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.
 
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

Access MSACCESS - Sorting report based on field calculated in the report 0
Joining Tables 2
One to may Or One to One? (350 fields all static) 24
Calculating inventory w/ blank field results 4
field calculation 5
High!! 8
using a calculation in a query 8
Join on a calculated field 3

Back
Top