Query not pulling all data

[here4real]

I created a query with 2 local tables. One has email address and phone numbers. The join is being done on first name and last name. It pulls in the email address fine. However, the phone number remains blank even when there is valid data. All of the fields are short text.

[June7]

Provide the SQL statement. Provide sample of data. If you want to provide db for analysis, follow instructions at bottom of my post.

Join should be on ID fields not name parts.

[here4real]

It is the query with Comm merged with cc. I tried doing it as an update query and storing it on the record as well as just a query. Nothing worked.

SELECT [RC Dem Committee w/ UPPER Names].*, [CC w/ UPPER Names].HPhone, [CC w/ UPPER Names].MPhone
FROM [RC Dem Committee w/ UPPER Names] LEFT JOIN [CC w/ UPPER Names] ON ([RC Dem Committee w/ UPPER Names].LName = [CC w/ UPPER Names].LName) AND ([RC Dem Committee w/ UPPER Names].FName = [CC w/ UPPER Names].FName);

[June7]

Well, the SQL looks fine.

I would have to review data.

[here4real]

Attached file has screenshots of data and structure

[isladogs]

Providing the table designs in Word isn't particularly helpful. However, based on that you should
1. Add a primary key field to each table and use that for your query join
2. Remove all spaces and special characters in table and field names
3. Remove what appears to be duplicate fields in each table e.g. First Name and FName and only have the remaining fields in one table. Data should only be entered once.

June asked to see example data. I missed that at first but it would make more sense to upload the actual database (or part of it).
I'm not surprised you are having problems with query joins with that data
If that is real data please remove the previous zip file, modify the data and reupload in Access

[here4real]

File is too big to attach. I can try to trim it down.

[June7]

You shouldn't post files with real names and emails.

I still can't determine cause of issue. Not even showing same names in both tables. Can't see entire output of query.

This is a case where need to work with db.

Strongly advise not to use spaces nor punctuation/special characters in naming convention.

[here4real]

1. Add a primary key field to each table and use that for your query join
I can add primary keys to both tables but there is nothing to relate them. The only relationship is first name and last name.

2. Remove all spaces and special characters in table and field names
I've never had to do that before but if it fixes it....

3. Remove what appears to be duplicate fields in each table e.g. First Name and FName and only have the remaining fields in one table. Data should only be entered once.
FName is just the UPPER CASE version of First Name in order to match the data (inconsistent data entry). FName in the Committe table was only added to see if it would work with stored data (through Make Table) rather than a Query. It didn't help.

[June7]

1. Is data imported from different sources?

2. No, that won't fix issue, just good practice. Otherwise have to remember to enclose in [].

3. UPPER CASE can be calculated when needed. No need to actually save into table.

[here4real]

The data is coming from 2 different sources.

See attached

[here4real]

I figured out the problem.

The data is crap. Last Name is actually first name and last name. Sometimes. Very inconsistent.

Thank you!