Q
Question Boy
Hello,
I am trying to manipulate a contact table (Id,FirstName,LastName,
Address,City,Prov,PostalCode,Phone1,Phone2,Email,...)
In the table I can have, and do have, multiple entry for a given postal
code. Basically, I have an entry for a Husband and another for the Wife.
Not the way I would have created the structure but I am stuck with it (cannot
be altered).
I am trying, and having trouble, creating a query that would 'group' the
records so that I get a unique listing by postal code. I used a Concatenate
function to combine the firstname for a given postal code but am now having a
problem telling the query to return the 1st phone1. if rec1 has phone1 use
it, otherwise use the phone1 from rec2...
For instance (- added to separate fields)
472-Devon-Julian-345 Farley-Marville,Quebec,J01AR3,5145555555,,,
876-Jane-Hunry-345
Farley-Marville,Quebec,J01AR3,5146666666,6135555555,[email protected],
I need to build a query to return
Devon & Jane,Julian--345
Farley-Marville,Quebec,J01AR3,5145555555,6135555555,[email protected],
Thank you for your help,
QB
I am trying to manipulate a contact table (Id,FirstName,LastName,
Address,City,Prov,PostalCode,Phone1,Phone2,Email,...)
In the table I can have, and do have, multiple entry for a given postal
code. Basically, I have an entry for a Husband and another for the Wife.
Not the way I would have created the structure but I am stuck with it (cannot
be altered).
I am trying, and having trouble, creating a query that would 'group' the
records so that I get a unique listing by postal code. I used a Concatenate
function to combine the firstname for a given postal code but am now having a
problem telling the query to return the 1st phone1. if rec1 has phone1 use
it, otherwise use the phone1 from rec2...
For instance (- added to separate fields)
472-Devon-Julian-345 Farley-Marville,Quebec,J01AR3,5145555555,,,
876-Jane-Hunry-345
Farley-Marville,Quebec,J01AR3,5146666666,6135555555,[email protected],
I need to build a query to return
Devon & Jane,Julian--345
Farley-Marville,Quebec,J01AR3,5145555555,6135555555,[email protected],
Thank you for your help,
QB