Find top in 2 week increments

[joe789]

Hi Folks,

I have created a program by which a user can enter any given time period (usually 12 months), and generate the top 5 people for that time period. I need to, if possible, automate a process that suggests one or several different 2 week time period(s) that is are shared with all the top 5 people from the time period. That is to say, if the query is ran for the year 2000 and the top 5 people are:

Al
Jim
Bob
Sally
Jen

I need the computer to suggest a 2-week period (such as February 4, 2000 thru February 11, 2000) in which the 5 people above appear in.

Is this possible?

Any help would be greatly appreciated.

Thank you,

Joe

 

[mark curtis]

You really need to attach a zip db so we can look at other criteria in the db to work out your request. To get a two week period when the users were all in the top range we need a value to base the range on?