Making query to bring in an actual name

  • Thread starter Thread starter Ray Murphy
  • Start date Start date
R

Ray Murphy

Hi All,

My knowledge of Access is pretty limited, but so far I've managed to
get through with minimal help via these groups, but I'm stuck again
and the only way out is to learn about making Queries from scratch
or ask you guys. (I'd pay an expert locally if I could find any).

What I need is something that will head me in the right direction
for converting an ID number in one column to the person's name in
a new column next to it, or alternatively in another table.

The tables I'm working with are for genealogy, where I have an ID
number for each person in the Individuals table plus separate table
for married couples which only have their ID numbers.

Currently I can make a query and get the people's ID numbers
alright, but I want the actual names instead.

Ray
 
Sounds as if you need to add the Individuals table to the query twice. Join
one copy to the table to the husband and one copy of the table to the wife
in the married couples table. That should let you select the information
from the tables for each spouse.
 
John Spencer said:
news:[email protected]...
Click to expand...


[Finding Names with ID Numbers]
What I need is something that will head me in the right direction
for converting an ID number in one column to the person's name in
a new column next to it, [...]
Click to expand...
[....]
Sounds as if you need to add the Individuals table to the query twice.
Join one copy to the table to the husband and one copy of the table to the
wife in the married couples table. That should let you select the
information from the tables for each spouse.
Click to expand...

Thanks John, I doubt if I would have thought of that for a long time.
I tried that but still got nowhere because I don't understand what I'm doing
half the time with Access, but in the meantime I found this page by Allen
Browne, which was easy to copy and get working like a charm (after replacing
horses with people). This will probably enable me to eventually frame the
original question in a way that will bring a quick resolution.

http://allenbrowne.com/ser-06.html

Ray
 
Ray Murphy said:
John Spencer said:
news:[email protected]...
Click to expand...


[Finding Names with ID Numbers]
What I need is something that will head me in the right direction
for converting an ID number in one column to the person's name in
a new column next to it, [...]
Click to expand...
[....]
Sounds as if you need to add the Individuals table to the query twice.
Join one copy to the table to the husband and one copy of the table to
the
wife in the married couples table. That should let you select the
information from the tables for each spouse.
Click to expand...

Thanks John, I doubt if I would have thought of that for a long time.
I tried that but still got nowhere because I don't understand what I'm
doing half the time with Access, but in the meantime I found this page by
Allen Browne, which was easy to copy and get working like a charm (after
replacing horses with people). This will probably enable me to eventually
frame the original question in a way that will bring a quick resolution.

http://allenbrowne.com/ser-06.html
Click to expand...

[Update]

RM: Problem solved (due to J. Spencer's vital clue and Allen Browne's
diagram).

It was simply a case of making a query using three genealogy tables --
(1) tblFamilies (married couples code numbers)
(2) tblIndividuals (people's basic data including names)
(3) tblIndividuals_1 (a copy of tblIndividuals)
and linking Spouse1 (husband) in tblFamilies to the IndKey in
tblIndividuals
AND
Spouse2 (wife) in tblFamilies to IndKey in tblIndividuals_1

The resulting query (as one would expect) provided a table which
showed all husbands and wives and their respective details.

Ray
 
Back
Top