Robin-
Not a good idea to add a column. 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
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
On Jun 15, 2014, at 5:45 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a table which includes two fields: [page] and [visitors].
How do I make a new column to rank the number of visitors per page?
Many thanks,
Robin Chapple
------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------
Yahoo Groups Links
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar