Look up Wizard

Resolved · High Priority · Version 2007

Wed 9 Mar 2011, 15:55 Edited on Wed 9 Mar 2011, 15:56 Delegate 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

Thu 10 Mar 2011, 16:03 Trainer Simon said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips