Add sequential number to select query

[Richard]

Hello all
I have one access table linked to a number of select querys that pulls
out certain data using the WHERE command.

How can I add a sequential number to the querys? I need to leave the
queries as Select and not MakeTable etc.

Current query looks like this:
SELECT [Table 1].*
FROM [Table 1]
WHERE ((([Table 1].field1)="1"))
ORDER BY [Table 1].ID;

many thanks in advance

Richard

 

[Allen Browne]

See:
Ranking and numbering records
at:
http://allenbrowne.com/ranking.html

The article discusses the options available to you.

 

[Richard]

Hello Allen

Thanks for the information. Cannot get to grips with the explanation
on the weblink, it's a bit too techy for me.

See:
    Ranking and numbering records
at:
   http://allenbrowne.com/ranking.html

The article discusses the options available to you.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Hello all
I have one access table linked to a number of select querys that pulls
out certain data using the WHERE command.

How can I add a sequential number to the querys? I need to leave the
queries as Select and not MakeTable etc.

Current query looks like this:
SELECT [Table 1].*
FROM [Table 1]
WHERE ((([Table 1].field1)="1"))
ORDER BY [Table 1].ID;

many thanks in advance

Richard- Hide quoted text -

- Show quoted text -