Row number in queries (1 Viewer)

[sadiq92]

If I have query that give me specifc date from table . How I put row number for that data.

for example , if it give me data of 5 rows , I want to add column for the rows ( from 1 to 5 ):
1 —— ——
2. —— ——
3. —— ——
4. —— ——
5. —— ——

 

[Isaac]

Check out this article from the Boards.

Row Number in a Query

I don't understand, why in a simple query, the row number, in access, looks like rocket science. Too difficult. Well I have a query, one field, say [Bol_reference], may return the below ABC123 ABC234 ABC345 ABC345 BCD123 BCD123 I would like to have a row number so that query will look like...

www.access-programmers.co.uk

 

[June7]

A very common topic.

Build a report and use textbox RunningSum property to dynamically generate row number.

 

[sadiq92]

A very common topic.

Build a report and use textbox RunningSum property to dynamically generate row number.

How I can do it
Can you explain Further?

 

[June7]

Set textbox ControlSource to =1 and RunningSum to OverAll.

Google for more details.