T
Ted Allen
In general, the approach to do this is to use a
correlated subquery or DCount() function to calculate the
rank. The key is to use the Amount field to limit the
domain being counted to just those greater than or equal
to the amount of the current line (in addition to the
fields necessary to correlate the records). If using a
subquery you have to alias the table name to refer to a
second instance of the same source table.
I can't really give any specific sql without knowing the
table structure and sample of the data contained, but
hopefully that helps.
-Ted Allen
anyone know how to do this in a Query?
correlated subquery or DCount() function to calculate the
rank. The key is to use the Amount field to limit the
domain being counted to just those greater than or equal
to the amount of the current line (in addition to the
fields necessary to correlate the records). If using a
subquery you have to alias the table name to refer to a
second instance of the same source table.
I can't really give any specific sql without knowing the
table structure and sample of the data contained, but
hopefully that helps.
-Ted Allen
having to 'Append' the results to a new table. Does-----Original Message-----
I'm trying to return a field in a Query that increments a number.
For example:
Color Amount Stack
------ --------- ------
Red 99% 1
Blue 93% 2
Orange 87% 3
Green 82% 4
Yellow 75% 5
Purple 21% 6
I'm trying to 'Stack Rank' the results but without
anyone know how to do this in a Query?