• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

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
0
Kdankwah
Asked:
Kdankwah
1 Solution
 
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
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now