Joining seperate lname and fname fields in a query

[Bkster]

I have a database where there is a field for the lname and a field for the fname. I have created a dynamic drop down list in Dreamweaver. I would like to connect to a query in access where it puts the lname and fname together. Any ideas or best practices on how this is done. Thanks in advance for the help

Brian

 

[scriverb]

Use this SQL to create a new query. Update the red table name with your table name:

Select (A.lname & " " & A.fname) as FullName
FROM tblYourTableName as A
Order by A.lname, A.fname;

Post back with any question you may have.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[Bkster]

Worked perfect thanks