Query Question

[CCPKGUY]

I have a query I am building in Access. I am using the fieldname call net which gives me the amount of money billed. I have about 800 records. Is there a way to rank the amount of money from the highest to the lowest? I need to pull the top 25 highest money billed.

 

[PHV]

Use the TOP predicate, eg:
SELECT TOP 25 * FROM yourTable ORDER BY [call net] DESC

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

I think if call net has more than one record with the same value (amount) all will be returned, so you may end up with a total > 25....

Beir bua agus beannacht!

 

[CCPKGUY]

Thanks...PHV and genomon. I was able to generate my report.