Thanks for this James, but the problem I have is I don't have a common field in the 2 tables. the description is the only field that are nearly the same, hence why I am looking for a partial match
Thanks
Dobbs
Hi
I wonder if anyone can help. I am new to access & stuggling with a simple query
I one table I have the following
PART LEADTIME
QT1234 8
QT123 6
QT2345 8
another table has full part numbers
DESCRIPTION PART NUMBER
QT1234-001 123456...
