Concatenate Query with AutoNumber in Access 2007
Posted on 2010-01-09
I am creating a phonebook/email address list. I have the user select a rank from a combo box, then enter first name in a text box, and last name in a text box.
In a query I set the following for the name: Name: Rank & " " &LastName&", "&FirstName
The query returns the following: PK_Rank_ID Last, First
"Rank" is a FK from tblRank, so I guess, technically it's returning exactly what I'm asking it to. But I see the actual rank (i.e. "CPT") in the combo box, not a number, so how do I get the query to look at the right value?