Public Function Numeration(Optional var) As Long
    Static n As Long
    If IsMissing(var) Then
        n = 0
    Else
        n = n + 1
    End If
    Numeration = n
End Function

SELECT (SELECT Sum(1) FROM Table1 p WHERE p.F1<=p1.F1) AS num, p1.F1 AS F1 FROM Table1 AS p1;

Public Function Numeration(Optional var, Optional i As Integer) As Long
    Static n As Long
    If n < i Then
       n = n + 1
    Else
        n = 1
    End If
    Numeration = n
End Function

SELECT Query3.F1, Query3.[Count-F1], MAX(Query3.num) AS num
FROM Query3
GROUP BY Query3.F1, Query3.[Count-F1]
HAVING MAX(Query3.num)>2;

SELECT DCount("f", "t","f<=" & CStr(f)), f
FROM t
ORDER BY f;

SELECT Val(DCount("F1", "Table1","F1<='" & CStr(F1) & "'")), F1
FROM Table1
ORDER BY F1;

SELECT (SELECT Sum(1) FROM Table1 p WHERE p.F1<=p1.F1) AS num, p1.F1 AS F1 FROM Table1 AS p1;

SELECT F, num FROM Query

SELECT F, num FROM Query HAVING (num<=30)

SELECT F, num, [num]-30 AS num2 FROM Query HAVING (num Between 31 and 60)

SELECT F, num, [num]-60 AS num2 FROM Query HAVING (num >= 61

SELECT Query1.F as F1, Query2.F as F2, Query3.F as F3 FROM (Query1 LEFT JOIN Query2 ON Query1.num=Query2.num2)_
LEFT JOIN Query3 ON Query1.num ON Query1.num=Query3.num2