Unanswered: Can you join a table to an expression created from another table?
I have 2 tables that I want to join in an Access query. Normally you just click and drag to join the fields, but that won't work in this instance. In the query design window, I created an expression from one of the fields in Table1 (Exp1: Right(someField,5)) which is displaying the last 5 characters of someField. I then add another table (Table2) to the query design, and I want to join Exp1 to a field in Table2. Any way to do this?