Hi all. In my database I have a linked table called NewClients (produced by another application and thus beyond my control) which has a field called [Fullname]. Typical contents are "John Paul Smith".
I have a local table called tblEmployees which includes two fields [LastName] and [FirstNames]. Typical contents are "Smith" and "John Paul".
The unmatched query that I require needs to find records with the [NewClients].[FullName] fields which are not matched by [Employees].[FirstNames] & " " & [Employees].LastName] expression. This should give me a list of people and contact details etc to add to my Employees table. In fact I intend to go on to make an update query to do just that.
So far, just to get it working, I have tried
SELECT NewClients.FullName, [tblEmployees].[LastName] & " " & [tblEmployees].[FirstNames] AS Expr1
FROM NewClients, tblEmployees
WHERE (tblEmployees.[FirstNames] & " " & tblEmployees.[LastName]) Is Null;
This runs but gives an empty recordset, I think because the query needs a JOIN clause but I can't get the syntax right.
Is there someone clever out there please?
I have a local table called tblEmployees which includes two fields [LastName] and [FirstNames]. Typical contents are "Smith" and "John Paul".
The unmatched query that I require needs to find records with the [NewClients].[FullName] fields which are not matched by [Employees].[FirstNames] & " " & [Employees].LastName] expression. This should give me a list of people and contact details etc to add to my Employees table. In fact I intend to go on to make an update query to do just that.
So far, just to get it working, I have tried
SELECT NewClients.FullName, [tblEmployees].[LastName] & " " & [tblEmployees].[FirstNames] AS Expr1
FROM NewClients, tblEmployees
WHERE (tblEmployees.[FirstNames] & " " & tblEmployees.[LastName]) Is Null;
This runs but gives an empty recordset, I think because the query needs a JOIN clause but I can't get the syntax right.
Is there someone clever out there please?