Hi
I have an issue that has been driving me mad for the past few hours and i can't seem to find any solution.
I have two tables that contain names and i want to run a query to show the ones that are common to both however one table has the names set out in four fields (Title, First Name, Middle Name, Last Name) where as the other table has just one field titled Name which contains everything.
What i would like to do is ideally run a query that compares the fields First Name and Last Name with the field Name
I have tried seperating the Name field out into seperate fields but this has proven most awkward due to the titles and people with two middle names.
I'm afraid to say i am a complete newcomer to access and so the simplest the solution the better.