separate fields

While using a predesigned Access DB I have stumped myself..I need to 
combine two separate name fields into one. Unfortunately the designer has 
separated the fields and I cannot find a way to bring them together. A 
query works but still leaves them isolated from one another. 

Askey, Chris; Chris.Askey@anheuser-busch.com

A: combining strings in query I'm not sure I understand your question: do you want to show the two values in one label (or so) like a field called firstname and a field called lastname must make the value personname? Perhaps like lblName.Caption = rs.Fields("FirstName").Value & " " & rs.Fields("LastName").Value Or do you want your query to append the both values and just return one? Just like Select FirstName & " " & LastName From Person Return