User Tools

Site Tools


vba:access:functions:rownr

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>
vba/access/functions/rownr.1530688947.txt.gz · Last modified: 04.07.2018 09:22:27 by yaslaw