Hi Access users,
Can you help me out?
I would to connect/compare two tabels.
Tabel 1
Field: Groupname
(example: ACROBAT)
Tabel 2
Field: Groupname
Status: Status
(example: X231-ACROBAT-10E8; finished)
Query Result: (ACROBAT; finished)
Would it be possible to connect these tabels with a "like" and wildcards statement? And give me the correct result?
i'm not formiliar with VB in Access to hopefully it possible without it?
the Query should be something like this??????
SELECT Tabel1.GroupName
FROM Tabel1
INNER JOIN Tabel2
ON Tabel1.GroupName like "*"&Tabel2.GroupName&"*";