Rank

[Guest]

I have read the prior posts but until I see it in my qry I won't understand
it. my query is as follows

SELECT Results.[CHARTER NO], Results.NAME, [Results]![TOT FID & RLTD ASSETS
- TOT FID ASSETS $]/[Results]![TOT ASSETS $ (BANK) (2004Q2)] AS [Fid Assets %
of Bank Assets], [Results]![FID ACTVS INC $]/[Results]![ADJ OP INC-TE $] AS
[Fid Inc % of Adj Op Inc], [Results]![FID & RLTD SVCS INC - CUSTODY & SKPG
$]/[Results]![FID ACTVS INC $] AS [Cust and Safekeeping $ of Fid Inc]
FROM Results
WHERE ((([Results]![FID & RLTD SVCS INC - CUSTODY & SKPG $]/[Results]![FID
ACTVS INC $])<0.08));


The current results of the above qry display a percentage, except for name
and charter. the last three fields are expressions (if that matters).

What I would like to show is the rank rather than the percentage for the
last three fields.
Ties are OK. Will it show a tie if the the percent shows "1%" when acutally
due to rounding it may be .005678 and another maybe .006394? Both show as 1%

a solution to this will be very helpful and will keep me from having to
export to excel, then rank and then import toa new table in access.

 

[Guest]

follow-up
the rank can be in a new field while keeping the percent in its existing field