Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

row_number equivalent MS Access for sequential id By Group

SELECT 
    t1.DOC,
    t1.TYPE,
    COUNT(*) AS [Ino Seq]
FROM 
    MyData AS t1
    INNER JOIN
    MyData AS t2
        ON t2.DOC = t1.DOC
            AND t2.Ino <= t1.Ino
GROUP BY
    t1.DOC,
    t1.TYPE
ORDER BY 1, 3
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #equivalent #MS #Access #sequential #id #By #Group
ADD COMMENT
Topic
Name
7+5 =