G
Guest
I am new to Access and having a difficult time. I have built some tables and
would like to create queries and reports. One of my tables has a key field
which, for the sake of simplicity, think of as a unique person_id. Two of
the fields related to this key field, think of as fields containing unique
person_ids for the parents. If I wish to build a query/report displaying the
names of the parents, not their unique person_ids, how do I do this?
e.g., key-field = person_id
other fields include name of person related to person_id and unique
person_ids for the parents.
I wish my report or query to list, say, the name of the person and the names
of his parents.
To the very nice and very intelligent people who help people like me, thank
you, thank you, thank you.
Sincerely, Marnie Shaw
would like to create queries and reports. One of my tables has a key field
which, for the sake of simplicity, think of as a unique person_id. Two of
the fields related to this key field, think of as fields containing unique
person_ids for the parents. If I wish to build a query/report displaying the
names of the parents, not their unique person_ids, how do I do this?
e.g., key-field = person_id
other fields include name of person related to person_id and unique
person_ids for the parents.
I wish my report or query to list, say, the name of the person and the names
of his parents.
To the very nice and very intelligent people who help people like me, thank
you, thank you, thank you.
Sincerely, Marnie Shaw