asp_learner
Registered User.
- Local time
- Today, 03:50
- Joined
- Jun 7, 2001
- Messages
- 46
Hi,
I am trying to make a query Select Top 10 for each person. I can do a select Top 10 but not for each person. I think the only way is to do it in vba code. Which is to run a report for the top 10 for the first person and then run the top 10 for the next person.
Can I otherwise do it in SQL.
Thanks,
Eva
I am trying to make a query Select Top 10 for each person. I can do a select Top 10 but not for each person. I think the only way is to do it in vba code. Which is to run a report for the top 10 for the first person and then run the top 10 for the next person.
Can I otherwise do it in SQL.
Thanks,
Eva