[mso] Re: Access Help

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).
http://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
*************************************************************

Other related posts: