Need big help! - Group By followed by Append Query

[atol]

Folks,
Here is the issue I have been struggling with. I have a table, which contains orders by individuals. Then I need to group those orders by certain criteria (let’s say by product type); I used a select query and grouped them by. However from that query, after i grouped them by, I want to be able to pick manually certain items and append them to another table where I will track activities with these aggregated product types. How can I do that?
I was thinking if I could use some sort of a form, but not sure how to handle the selection part before I append. If there is another simpler way to handle this scenario please let me know.
Any advice is greatly appreciated!
Rgds,
Atol

 

[stopher]

I would put the results of the group by query into a holding table which also includes a "pick" field. I would have a form based on this holding table so that the user can choose require records by ticking the "pick" field. Then you can just run your append query with pick=true as the criteria.

hth
Chris

 

[atol]

Chris,
This is really good approach. Thank you very much. Just a quick clarifying question - since the group by quiery is a dynamic one (meaning it is pulling data from a table that constantly gets updates), should I use an update query to update the holding table?

 

[stopher]

An update query will do fine. But you'll have to run a delete query on the holding table first to erase any previous records.

Chris

 

[atol]

oh i see...yes, that makes a lot of sense...
Chris, thanks a lot man!