Anthony, That will do it. Switching between SQL and Access gets to be sticky sometimes. You can do it with the SQL code you have where you use the field1 & Field2 as NewFieldName format or your original attempt does work if you use part of it in the gui and make the new field in it name: fname & " " & lname. Both work, its just a matter of where you use them. James -----Original Message----- From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx] Sent: Monday, November 25, 2002 9:08 AM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Help :VSMail MX3 Dian- I just reread your original post, maybe when using the lookup wizard concatenation is not a legal operation. It's just a guess. As a test open a new query and try the query in SQL view if it works as a standalone query then the problem might be with using a lookup as a datatype. Disregard all the above it can be done. Try this SQL SELECT [TrainingStudents].[StudentID], [TrainingStudents].[FName] & " " & [TrainingStudents].[LName] AS name FROM TrainingStudents; When in table design view the lookup tab, the row source click the ... and paste the above SQL into the SQL view. click the ! to see the result. It will hopefully work. then in the properties of the lookup set this: set the bound column to 1 set the column count to 2 set the column heads to no set the column widths to 0";1" that should do it -Anthony ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************