Would anyone tell me how you would
rank a records in (as/400) db2
product prct_count rank OR rank
aaa 99 1 4
bbb 50 2 2
eee 50 2 2
ccc 20 4 1
Thank in advance
option A
open new query, DO NOT choose any table, then close table wizard
click query -> sql specific on the file menu
Then click on "pass through"
OPtion B
Dim qdfPT As QueryDef
Dim colSel As String
Dim varitem As Variant
For Each varitem In lstTable.ItemsSelected
' Print...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.