microsoft.access.courses - looking up two field

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft.access.courses - Looking up two field in another table and merging them

microsoft.access.courses - Looking up two field in another table and merging them

resolvedResolved · Low Priority · Version Standard

Linda has attended:
Access Intermediate course

Looking up two field in another table and merging them

I am trying to write a database where sheet A displays names from sheet B , and although the names are displayed in three fields in on sheet B, they should show as one field on the sheet A. Is possible?

RE: Looking up two field in another table and merging them

Hi Linda

This sounds like a combination of performing Maketable Query on Sheet B where a concatenation calculation of the name fields in Sheet B is required to create a new table named Sheet A

Steps are as follows
1. Perform a query on table = Sheet B
2. In the Query perform a calculation similar to the following

SheetB.field1 +SheetB.field2+SheetB.field3
or
SheetA.field1 +(" ")+SheetA.field2+(" ")+SheetA.field3 if spaces are required between the names

3. Select from the Query menu > Maketable query, and name table as Sheet A
4. Select Query> Run
5 Save query for later use




RE: Looking up two field in another table and merging them

The problem is sheet A already exists. The field with the info from sheet B is just one of many. I am literally trying to format one cell in sheet A to display three other cells from a different sheet sheet B. Creating sheet A from sheet B is not really an option, because ther is also going to be a sheet C & D from which similar information will need to be extracted. Any more ideas?

RE: Looking up two field in another table and merging them

Follw the same process Orok suggested, but instead of creating a new table, simply create a lookup from table A to the new query, pointing to the field that has the 3 names merged.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips


Server loaded in 0.08 secs.