Ranking a calculated column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

luvspeanut - 30 May 2006 19:57 GMT

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.

Reply to this Message

KARL DEWEY - 30 May 2006 21:05 GMT

Post your SQL.

> 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.

Reply to this Message

luvspeanut - 30 May 2006 23:33 GMT

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.

> Post your SQL.
>
[quoted text clipped - 3 lines]
> > Life])/Count([ST_Code]),2). Article ACC2000 didn't work - I have Access
> > 2003. Any help you can give would be appreciated.

Reply to this Message