how do I make the lastname and first show

How do I make the last name and first name show in the box with red circle around.  See attached. screen screen
KdankwahAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
JVWCConnect With a Mentor Commented:
You'll need to change the layout of your combo for the different nomber of columns...

Something like:

SELECT [Contacts Extended].[Last Name] & " " & [Contacts Extended].[First Name] AS FullName, [Contacts Extended].ID
FROM [Contacts Extended]
ORDER BY [Contacts Extended].[Last Name], [Contacts Extended].[First Name], [Contacts Extended].ID;

Cheers
JC
0
 
Barry CunneyCommented:
If the box you are referring to is a combo box the for the rowsource query you need a expression field in the query which concatenates the forst name and last name from the separate first name and last name fields in the relevant underlying table - In Design select box and press F4 for the poperties
0
 
KdankwahAuthor Commented:
This is the syntax I am using on the field.  I need to get it to read first and lastname together

SELECT [Contacts Extended].[Last Name], [Contacts Extended].[First Name], [Contacts Extended].ID
FROM [Contacts Extended]
ORDER BY [Contacts Extended].[Last Name], [Contacts Extended].[First Name], [Contacts Extended].ID;
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Eric ShermanAccountant/DeveloperCommented:
In your ComboBox, what is the Bound Field (Employee ID, Last Name, etc.)???

Can you upload a sample db in Access 2000 format???


ET
0
 
KdankwahAuthor Commented:
Its bound to last name, but I can change to ID.
0
 
Eric ShermanAccountant/DeveloperCommented:
<<<<<Its bound to last name, but I can change to ID.>>>>>>

What do you need it to be??

Can you upload a sample ...  will probably make it a lot faster.

ET
0
 
Eric ShermanAccountant/DeveloperCommented:
Also, I would change the Bound Field to a Unique ID field so you will handle duplicate last names properly.

ET
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.