By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,482 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,482 IT Pros & Developers. It's quick & easy.

Need a combination - top 3, and group by...

P: n/a
Hi all

I want a query that will return from a series of candidates and votes
for a number of positions, the top three candidates for each position.

I can of course, return the top candidate for each position, or the
top three polling candidates for any position... Anyone got any
bright ideas?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have you tried joining a query that returns a single record for each
position with a query that returns the top three for a given position on the
unique identifier(s) for position? That would seem to be the simplest
approach.

Larry Linson
Microsoft Access MVP

"Dave Mc" <mc**********@hotmail.com> wrote in message
news:61**************************@posting.google.c om...
Hi all

I want a query that will return from a series of candidates and votes
for a number of positions, the top three candidates for each position.

I can of course, return the top candidate for each position, or the
top three polling candidates for any position... Anyone got any
bright ideas?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.