I have it automated with code. I set the first recordset to show the group id from the temp table, .movefirst, pull the group id, set the second recordset to the user+group table, filtered by that group id to return only those 0-4 (typically users), .movefirst into the user table, pull the user names, loop to string them together until .eof, write the sting to a field in the temp table. Then export. 2 minutes. I would like to make it faster by not looping through ALL records in the temp group table, just the ones that are going to return results. That's why I want to add a count to the temp table, so that I can set the recordset not to the entire table, but instead to the temp table filtered where the count is >1. Each cycle through the entire temp group table (and subsequent loop through the user group table is taking 50 seconds. Whereas my SQL queries are taking 1 second).
Regarding the update with a nested query. I'll stop thinking about it if it's not possible. I'll join the nested query to the append query that made the temp table in the first place.
Thanks!!