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

Kamis, 23 April 2015

Re: [MS_AccessPros] Query or a report?

Ah. I understand.

I have
EmailsTBL

Auto Assigned Key field
Contact ID Field from my contact table
Email
Primary? Y/N. I can check this if I have more than one emails. Not working well from the administrative side but I have other fish to fry.
Status (bounced back, unsubscribed). I keep these because I get contacts from different people. If I just delete an email from the table when it bounces, someone else will give me 50 new contact records and it will be back in my database.

Thanks

On 4/23/2015 9:04 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:

Jan,
By categorizing emails, I meant something similar to the way you might categorize phone numbers: Home, Work, Cell, etc. The category titles would be great candidates for Column Headings in your crosstab query.

Duane Hookom, MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 23 Apr 2015 08:05:43 -0600
Subject: 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