Merging Lists

Guessed · #1 07-10-2022, 09:17 PM

Try adding a Query in Access to restructure the data. In SQL view this might look like this

Code:

SELECT Person, "Comm 1" AS Committee
FROM Table1
WHERE (((Committee1)=True));

UNION ALL
SELECT Person, "Comm 2" AS Committee
FROM Table1
WHERE (((Committee2)=True));

UNION ALL
SELECT Person, "Comm 3" AS Committee
FROM Table1
WHERE (((Committee3)=True));

You should be able to use that query as your merge source (or use it as the basis for an Access Report)

Souriane · #2 07-11-2022, 06:39 AM

Guessed!!! you are a Master!!!!

When I saw you second answer I wanted to bang my head on the wall! I have never done SQL before, always avoided it because it is to hard for my little head! But Monday Morning, 8:30, why not try it. Guessed made the effort to answer me, I'll make the effort to understand...!

It took me an hour to figure out. Trial and Error over and over. Until... yeahhhh!!! I tried with only 3 committees at first and I finally got the result I wanted!!!! I will do it with the 25+ committees later. But I am over the moon!

And, oh!! Now that I understand how SQL works, I might begin to learn and work with it in the future as it look easier to do it this way than in the QBE mode! And you can do things way more complex!!

Thank you soooooo much! You made much more than my day!!!!

Souriane

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two lists and extracting values missing from both lists	Dave T	Excel Programming	4	11-01-2018 11:51 PM
Creating global contact lists (distribution lists) Outlook 2011 Mac	pengyou	Outlook	0	09-10-2016 02:18 PM
I want to create a lists within lists (nested merges)	AndyS	Mail Merge	10	12-11-2015 03:05 PM
Merging bibliographies with word documents using separate master lists	Cimballi	Word	3	07-01-2014 03:45 AM
Merging Distribution Lists	twiga	Outlook	0	12-27-2009 08:23 PM