hatic
asked on
What is the equivalaent syntax for DENSE_RANK over for MS Access?
how can I write this in access?
SELECT dense_rank() over(partition by field1, field 2 order by field 3) as name
SELECT dense_rank() over(partition by field1, field 2 order by field 3) as name
You can't because MS ACCESS don't have partioned tables feature.
Are you looking for this?
ACC2000: How to Rank Records Within a Query
http://support.microsoft.com/kb/208946
ACC2000: How to Rank Records Within a Query
http://support.microsoft.com/kb/208946
As mentioned earlier, dense_rank() function is not available in Access.
RANK() equivalent can be achieved as given below:
http://www.dbforums.com/microsoft-access/1637016-rank-records-access-sql-row-number.html
But DENSE_RANK() is not available..
RANK() equivalent can be achieved as given below:
http://www.dbforums.com/microsoft-access/1637016-rank-records-access-sql-row-number.html
But DENSE_RANK() is not available..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> I wrote dense rank and row number functions in vba, copied my table to a recordset and find rankings with the functions and copy them back to a table
If this problem was resolved, you can close out this question right..
If this problem was resolved, you can close out this question right..