Re: [MS_AccessPros] Ranking vistors to web site

 

Thanks John,

That gave me the result that I needed.

At 16/06/2014 10:50 AM, you wrote:

>Not a good idea to add a column.

That was poor language. I did intend the result which you gave.

>You can do it in a query:
>
>SELECT MyTable.[Page], MyTable.Visitors, (SELECT COUNT(*) FROM
>MyTable As T2 WHERE T2.Visitors >= MyTable.Visitors) As Rank
>FROM MyTable

You did suggest a similar technique some years ago. I recall it now
but I had forgotten.

Is this documented somewhere so that I can apply the technique if it
arises again? I assume that I cannot use the 'Design View' but must
use an SQL technique.

Thanks again,

Robin

__._,_.___

---

Posted by: Robin Chapple <robinski@westnet.com.au>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___