Combining 2 different tables to create a query

[pltnsgt]

I am rather new to access and only have a public education, so be gentle. My problem is I have made two tables within access. The first one is names and other information (5800 accounts). The second one is names and phone numbers (2300 accounts). The names are in the system exactly the same for both tables. All the names on the second list are contained within the first list. I need to create a table or query that will match the names with the phone numbers and also show me the names that I do not have the phone numbers for. I would really like to have one massive table that contains all the information from both lists. I have made a relationship between the two tables based on the person’s name. Any ideas? Thanks.

 

[Sanjeet Prasad]

Try this :

SELECT
FROM [Names] INNER JOIN Names_Phone ON Names.names = Names_Phone.names;

 

[pltnsgt]

Can you be a little more detailed in how I am to do that? I am sorry but I am very new a access. Thanks.

 

[pltnsgt]

Let me try to explain it better. The first table name is 5480 Master Data, the second is 5480 Meal Collection. I entered the syntax bellow under the Criteria: and Name: but I get an “Enter Parameter Value” message when I try to run it. This results in me getting no results from the query. Any ideas? Thanks.


FROM 5480 Master Data INNER JOIN 5480 Meal Collection ON 5480 Master Data.name=5480 Meal Collection.name

 

[neileg]

Because you have spaces in your object names, you need to wrap the names in square brackets, thus

FROM [5480 Master Data] INNER JOIN [5480 Meal Collection] ON [5480 Master Data].name=[5480 Meal Collection].name

This is one of the reasons why spaces (and punctuation) should not be used in odject names.