Q: 
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