Re: [MS_AccessPros] Query or a report?

Sorry. I could not upload the file. It is attached as a spreadsheet. Let
me know if you don't get it.



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
> <mailto:duanehookom@hotmail.com> [MS_Access_Professionals]
> <MS_Access_Professionals@yahoogroups.com
> <mailto: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
> <mailto:MS_Access_Professionals@yahoogroups.com>
> From:MS_Access_Professionals@yahoogroups.com
> <mailto: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
>
>
>
>
>
>
>
>
>
>
>
>
>



[Non-text portions of this message have been removed]



------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/