J
Joanne
HELP!
THE SITUATION:
NAME table contains 1 record for each unique first_name and last_name.
ADDR table contains addresses for people in the NAME table.
There is a one to many relationship between the ADDR and NAME tables.
Some ADDR records are used by multiple NAME records (i.e., multiple people
live at the same address-e.g., married).
Some ADDR records have only one NAME record.
Example:
Jane Doe-->addr1
John Doe-->addr1
Abraham Lincoln-->addr2
THE QUESTION:
How do code a query so that I get the following result (to be used for
addressing envelopes)
Jane & Joe Doe Addr1
Abraham Lincoln Addr2
or
First_name (First_name) Last_name Address [where (First_name) is only
present when Address is a duplicate]
Appreciate your suggestions.
thanks.
THE SITUATION:
NAME table contains 1 record for each unique first_name and last_name.
ADDR table contains addresses for people in the NAME table.
There is a one to many relationship between the ADDR and NAME tables.
Some ADDR records are used by multiple NAME records (i.e., multiple people
live at the same address-e.g., married).
Some ADDR records have only one NAME record.
Example:
Jane Doe-->addr1
John Doe-->addr1
Abraham Lincoln-->addr2
THE QUESTION:
How do code a query so that I get the following result (to be used for
addressing envelopes)
Jane & Joe Doe Addr1
Abraham Lincoln Addr2
or
First_name (First_name) Last_name Address [where (First_name) is only
present when Address is a duplicate]
Appreciate your suggestions.
thanks.