[mso] Re: Access Help

Rats! This didn't work???? I am still getting a syntax error saying I
can't have all the & " " & stuff in the string????

Dian Chapman
Technical Consultant, Instructor,
Microsoft MVP & TechTrax Editor

Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html
Tutorial web site: http://www.mousetrax.com/techpage.html
TechTrax Ezine: http://www.mousetrax.com/techtrax/

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Colli, Anthony G
Sent: Monday, November 25, 2002 9:54 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Help


Dian-

 This will display first name and last name in the same column.

SELECT [TrainingStudents].[StudentID], name: [TrainingStudents].[FName]
& " " & , [TrainingStudents].[LName] FROM TrainingStudents; 

-Anthony




 

 

-----Original Message-----
From: Dian Chapman [mailto:dian@xxxxxxxxxxxxx]
Sent: Monday, November 25, 2002 9:59 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access Help



Hi folks...

My turn to ask for help! I used to know how to fix this, but can't
remember and it's making me nuts. 

I have a table of my course/student info. The student's names are pulled
from a student table. When I click the drop down, it shows both columns
for first name and last name. But when I select a name, only the first
name shows up in the table. So I have to continually click the drop down
to verify last names, as they don't know up in the linked table record.
I want both the first and last name to show in this second table, pulled
from those two fields in the first table. Here's the query that the
lookup wizard created:

SELECT [TrainingStudents].[StudentID], [TrainingStudents].[FName],
[TrainingStudents].[LName] FROM TrainingStudents; 

What do I need to do to this or some other field to get the FName LName
to be displayed when I select a name?

TIA for any help...

Dian Chapman
Technical Consultant, Instructor,
Microsoft MVP & TechTrax Editor

Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html
Tutorial web site: http://www.mousetrax.com/techpage.html
TechTrax Ezine: http://www.mousetrax.com/techtrax/

*************************************************************
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
*************************************************************


*************************************************************
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
*************************************************************

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