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.
