ExcelKid_10
Board Regular
- Joined
- Mar 17, 2004
- Messages
- 87
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
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