MS Access: Numbering in queries

Asked Aug 08 '20 at 13:55

Active Aug 08 '20 at 13:56

Viewed 58 times

It is necessary to make the numbering in the queries, it should just be displayed independently of other data. An example of code that is not particularly needed here.

SELECT Left([ФИО],InStr([ФИО]," ")-1) AS f,  
   Mid([ФИО],InStr([ФИО],"")+1,InStrRev([ФИО]," ")-InStr([ФИО]," ")-1) AS i, 
   Mid([ФИО],InStrRev([ФИО]," ")+1) AS o
   FROM ["Администрация"]

edited Aug 08 '20 at 13:56

Gordon Linoff

1,242,037
58
646
786

asked Aug 08 '20 at 13:55

Vyacheslav Strachylin

1

Is there an ordering that you care about? If so, it is not obvious. – Gordon Linoff Aug 08 '20 at 13:56
MS Access does not natively support row-numbering in SQL queries. You can do it in application-code though, of course. – Dai Aug 08 '20 at 14:00
Maybe [this example](https://www.599cd.com/tips/access/140703-row-number/)? – Paul T. Aug 08 '20 at 14:38
Row number can easily be calculated in textbox on report using RunningSum property. – June7 Aug 08 '20 at 20:37

MS Access: Numbering in queries

0 Answers0