Linking fields between a query and table

[Access_Novice]

In query design view, I have added a query with column (nameA) of names and a table with a column (nameB) of names. I am linking these two fields (nameA and nameB) which contain names. The names are spelled exactly the same so I should get results. Both fields are of the same data type.



But even when I add only the field with names from the query (the field called nameA), I don't get any results.

What is wrong here? Are there restrictions about linking a query to a table?

[June7]

Queries can join to tables or queries.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Access_Novice]

Queries can join to tables or queries.

If you want to provide db for analysis, follow instructions at bottom of my post.

In the attached database, my problem is with the query called subPayments. The subpayments table has a name "Cardenas, Steven" which also appears in the query called qryTimeCollection. The name is spelled the same in each case, so I don't know why it doesn't appear in the query results.

[June7]

The problem is with the lookup that is set for the subEmployee field in subPayments. This is why lookup with alias in table is bad idea. The actual value saved in subEmployee field is the billingAccount value CARDENAS1 - not the name Cardenas, Steven. Remove the lookup settings from the table and you will see the true values of the field. http://access.mvps.org/access/lookupfields.htm

There are no primary keys defined on any table.