transpose fi

L

Laynne Botes

I am busy with a access database where I have a table with a family tree and members

Looks like this :

Table: [Family]

ID ( Autonumber ) , Parent1(lookup) , parent2(lookup) , Child 1(lookup) , Child 2(lookup)

All 4 members are chosen by lookup from tabel![person_details].name

I need to be able to set up a query as follow :


Input:

Criteria = 1

Output:

"ID" "members"
1 parent1
1 parent2
1 child1
1 child2

I would appreciate if someone could help me , I am new to Access and have spend a lot of
time on this , but no success.

Thanks
 
Top