I have a table with three fields
- TBl.ID
- TBL.Contact_ID
- TBL_Email address
TBL.Contact_ID links to the name and address table and can have multiple entries
TBL.Email_address records ANY email address I get for a contact. We usually get these from sign up sheets and you would be surprised how many email addresses a person has and uses interchangeably.
I tried to set up a crosstab with TBLContact_ID as the rows and TBL.Email_address as columns. It seems to result in one column for each unique email address. How can I generate a query that shows the following?
TBL.Contact_ID, TBL.Email_address(Value 1), TBL.Email_address (Value 2).............
Thanks
_
__._,_.___
Posted by: jan.hertzsch@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar