microsoft.access.courses - 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