ACCESS FEED: Re: [MS_AccessPros] Query or a report?

Kamis, 23 April 2015

Re: [MS_AccessPros] Query or a report?

Hi Duane:

I have not yet tried a crosstab query. I will work on it this afternoon. Let me take a shot at it as I usually just need to know the proper direction.

I am not sure what you mean about the email addresses being standardized or not categorized. Could you elaborate?

Thanks

On Apr 22, 2015, at 6:14 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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