Ranking a calculated column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've read through the threads and haven't found anything that has helped. I
have a calculated column that I would like ranked. It shows average
application production - here's the calculation that I use: Round(Sum([Total
Life])/Count([ST_Code]),2). Article ACC2000 didn't work - I have Access
2003. Any help you can give would be appreciated.
 
Rank: (Select Count (*) From June_Founders Where [Avg Apps]
<=[June_Founders]. [Avg Apps]+1;)

I know this isn't right but don't know what to do. Thanks.

KARL DEWEY said:
Post your SQL.

luvspeanut said:
I've read through the threads and haven't found anything that has helped. I
have a calculated column that I would like ranked. It shows average
application production - here's the calculation that I use: Round(Sum([Total
Life])/Count([ST_Code]),2). Article ACC2000 didn't work - I have Access
2003. Any help you can give would be appreciated.
Click to expand...
Click to expand...
 
Back
Top