Loop through RecordSet and then Append

[ExcelKid_10]

Hello-

What I have is two tables. Within the first table there are just two fields: Name and Category. In the second table I have the following three fields: Name, Category, % Total.
What I would like to do is create an append query that loops through each name taking the Top 10 values and append it into another table.

Any thoughts on some basic VBA code to structure this? All web searches I've come across have been without success.

Thanks!

EK

 

[pooratlas]

Kid:
Tell us more....
Table1 - these fields are both text?
Table2 - two text fields and value field?
Append source table, destination table?
Top10 values of what?
Append it... what is it?