Combine multiple fields into one

[rpyee15]

Win 7 64-bit
Access 2010 32-bit

My base data table has a list of group names, the address at which the group meets, and the day/time each group meets. There is a separate record for each day/time the group meets. Most groups only meet once (one record), but there can be up to four meetings each week (four records). I've made two new tables from the base table. The first one is the Group name and Address, so there is only one unique record per group. The second table is the meeting table. Each group has a record for each day/time they meet (1-4). I am trying to get to the point that I can export the group name, address, and one field that lists all meetings, whether it be one meeting or up to four meetings. I'm so very rusty that i can't figure out how to combine the day/time fields into one. There's probably a very simple way in which to reach this objective, but I'm at a loss.



Any help you can provide would be greatly appreciated!
RitaY
Area 52 Website Coordinator

[pbaldy]

How about:

http://allenbrowne.com/func-concat.html