<div>
Hi alankwan <br />
<br />
If you have a numeric primary key field in your table, autonumber is good, you can do something like this:<br />
<br />
SELECT (Select count(*) from TheTable where ID &lt;=T.ID) AS [Counter], T.ID<br />
FROM TheTable AS T<br />
<br />
Returns:<br />
<br />
Counter &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID<br />
1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5<br />
<br />
Alan<br />
<br />

</div>


Hi alankwan

If you have a numeric primary key field in your table, autonumber is good, you can do something like this:

SELECT (Select count(*) from TheTable where ID <=T.ID) AS [Counter], T.ID
FROM TheTable AS T

Returns:

Counter      ID
1      1
2      2
3      3
4      5

Alan



<div>
thank you ...but it not works if i got 'where' clause to filter data
</div>


thank you ...but it not works if i got 'where' clause to filter data

<div>
<div class="content wysiwyg-content">
How to retrieve datas with running number using access query ? eg. i got three data ...then show me 1 ... 2 .. 3 ...
</div>
</div>


How to retrieve datas with running number using access query ? eg. i got three data ...then show me 1 ... 2 .. 3 ...

How to retrieve data with running number using access query ?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.