Jan,
You might consider a crosstab query. Your email addresses would be the value. I'm not sure if the email addresses have standard types or are not categorized.
If you need assistance, it would help if you provided the significant table and field names as well as their relationship.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Apr 2015 14:52:20 -0700
Subject: [MS_AccessPros] Query or a report?
I have a table with name & physical address, then a second table with emails. I use two tables because I have multiple email accounts for some contacts. I also do this for "tags". (Attended fundraiser, Volunteer, Hostile, etc)
I can run a query to extract all my data to excel but I get multiple lines for records with more than one email or more than one tag.
I want to produce output that I can load to excel with one record per contact. I am thinking somehow to magically put the second email and second tag into a column for output. My user(s) are extremely Excel focused.
Any thoughts on how to do this?
Thanks
You might consider a crosstab query. Your email addresses would be the value. I'm not sure if the email addresses have standard types or are not categorized.
If you need assistance, it would help if you provided the significant table and field names as well as their relationship.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Apr 2015 14:52:20 -0700
Subject: [MS_AccessPros] Query or a report?
I have a table with name & physical address, then a second table with emails. I use two tables because I have multiple email accounts for some contacts. I also do this for "tags". (Attended fundraiser, Volunteer, Hostile, etc)
I can run a query to extract all my data to excel but I get multiple lines for records with more than one email or more than one tag.
I want to produce output that I can load to excel with one record per contact. I am thinking somehow to magically put the second email and second tag into a column for output. My user(s) are extremely Excel focused.
Any thoughts on how to do this?
Thanks
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar