Forum home » Delegate support and help forum » Microsoft Access Training and help » Look up Wizard
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Look up Wizard
Resolved · High Priority · Version 2007
Reply Wed 9 Mar 2011, 15:55
Edited on Wed 9 Mar 2011, 15:56Delegate Vivien said...
Vivien has attended:
Access Introduction course
Access Intermediate course
Look up Wizard
I have a Employee list/ table with Fields to enter Firstname and Lastname(also created a form for that). Also have a table for the Working Hours with Field Employee name which was created as a look up wizard(also have a form for that). Now my problem: I can look the names up but it only displays the first name-also in the look up I see both, but really I need to have first and last name displayed. Please help.
Many Thanks
For upcoming training course dates see: Pricing & availability
RE: Look up Wizard
Hi Vivien,
Thank you for your question.
Create a query based on the table that contains the First and Last Name fields.
Add the First and Last Name fields into the query. Save the query with a name.
Click into the next available blank field name and type the following:
FullName:[FirstName]&" "&[LastName]
This will concatenate the First Name followed by a space folllowed by the Last Name when you view the results.
e.g. Simon Khan
Then go to the foreign key field in the hours table and choose Lookup Wizard. Choose the query and then select the field FullName. It will then display the Full Name rather than just displaying the FirstName.
I hope this answers your question.
Let me know.
Regards
Simon
|