Rabu, 22 April 2015

[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: 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