Cross reference expression in query

[Aurillius]

Hi guys,
I have a table of text values that is altered to match another table and then cross-referenced in a query. How do I create the query without creating a second query to reference.

Table 1
(Field)Part# = "M" & Mid([Part#], 2)

Table 2
(Field)Part# = [Part#]

Thanks,
Aurillius

 

[PHV]

You want to join Table1 and Table2 ?
SELECT field list
FROM [Table 2] T2 INNER JOIN [Table 1] T1
ON T2.[Part#] = 'M' & Mid(T1.[Part#],2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244