Skip to Content
Former Member
Nov 21, 2005 at 08:00 PM

How to develop this query?


Hi all,

I have a requirement similar to this- I have a list of planned costs for different phases in a single calendar year. So this list looks like this:


2004 P1 1,200

2004 P2 900

2004 P3 1,300

2005 P1 1,400

2005 P2 1,200

2005 P3 800

2005 P4 700

Now I have to define a query which plots these costs against the position of each cost in the value range for a year. Simply put, I'll have to find out the olympic rank of each cost data within all the cost data for each year. So, 2004 will have a range of 3 values and 2005 will have a range of 4 values.

After this I'll have to find out the max. rank for each year.

So can someone please tell me how to go about this?