Recent content by AnalystNY1985

Thank you very much for reaching out. I have run the following SQL queries and have come up with results- but I am pretty sure it is not capturing everything. SELECT * FROM Table2 INNER JOIN Table1 ON Table1.GroupNAME Like '*'+Table2.CheckNAME+'*'; SELECT * FROM Table2 INNER JOIN Table1 ON...

Hello, :confused: I am in Access 2007 and am having a problem writing a SQL query to match names that are similar, but do not match. Here is the scenario: Table1 FirstName LastName Employer Staff ID (PK) Table2 Payment Payee Date PaymentID (PK) I am trying to match the payment...