Hello all,
Long time lurker/reader, first time poster. I have a table of the form:
[Policy Number] [# of drivers needed] [Driver #] [Driver Factor]
1 3 4 2.00
1 3 2 2.00
1 3 1 1.50
1 3 3 1.25
1 3 5 1.25
1 3 6 1.00
2 2 2 2.50
2 2 1 2.00
2 2 3 2.00
... ... ... ...
Note that the table is sorted ascending by [Policy Number] then
descending by [Driver Factor].
I have an Access problem that consists of two parts. I don't mind
editing SQL, but want to avoid VB if possible (though I recognize that
it might not be possible.) I am a novice at both.
Part 1. I know how to sort use the SQL TOP function to get the records
with the n highest driver factors in the table or the "top" n records
in the table. What I need is to get the top n records for each policy.
Part 2. The number of records I need, n, varies by policy number and
is equal to [# of drivers needed].
Any help is appreciated.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
