This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
vba:access:functions:rownr [04.07.2018 09:22:27] yaslaw |
vba:access:functions:rownr [04.07.2018 09:23:00] (current) yaslaw [Beispiele] |
||
---|---|---|---|
Line 14: | Line 14: | ||
===== Beispiele ===== | ===== Beispiele ===== | ||
<code sql>SELECT | <code sql>SELECT | ||
- | rownr(123, t.feld_eins) , | + | rownr(123, t.id) , |
t.* | t.* | ||
- | FROM t_1 t</code> | + | FROM tbl_data t |
+ | ORDER BY t.sort</code> | ||
===== Code ===== | ===== Code ===== | ||
<source '%%fpath%%/%%fname%%' vb> | <source '%%fpath%%/%%fname%%' vb> |