Concatenation of two lookup strings in access

[myaccesstuitions]

Sir



I have stored all the first names and last names in Names table
I am using this as lookup source for my other tables for filling of names quickly
when I try to concatenate its showing up a numerical value... how do I get the full name alphabetically...
Rajkumar Jyothi

[orange]

Sounds like your using some lookup at the table fields level. You haven't given much detail,
but you should read this.

[myaccesstuitions]

Thank you....I think.... I didn't present my problem clearly.... I need to concatenate two lookup fields of a table with the help of a query

[orange]

I need to concatenate two lookup fields of a table with the help of a query

Please provide more details --table structure, field names...
Do you have lookups at fields in table level????