I'm not sure if this can be done (but at UA it can always be done!!). I have a query that runs when a command button is clicked on a form (along with a few other action queries). The results of the query are grouped, with a quantity summed for each group record.
What I then need to do is take this queries results- basically a list- and put them into a memo field in a table. I've done a lot of Append Queries that work really well so I was hoping to turn this query into an Append Query to do that. Problem is I need all the queries records to go into only ONE record of the other table (and in the memo field). For Example:
The query might bring these results:
Marie 4 hours
Steve 2.5 hours
Jon 12.5 hours
I need it to look like this in the memo field of one record in another table (preferably in this 'paragraph' format, each on it's own line in the memo field). Is it possible to do this? Many thanks in advance!