Number items with a query

[HansBades]

I have a query that produces a list of SKUs based on certain criteria. How can I add a field in the query to each SKU to number the list in numerical order. For instance, if the query returns

SKU

Yhlo23

Thj23

Whj24

How can I get it to number the SKUs based on the results of the query as such?

SKU	Order
Yhlo23	1
Thj23	2
Whj24	3

Thank you!

[Welshgasman]

I have Google on this laptop.
This is what it produced on a simple search?

https://www.google.com/search?q=incr...hrome&ie=UTF-8

[orange]

I have a table with several animals.
This query selects those animals whose name begins with "G" and adds a sequential index number.
AName is the animal name and animalId is the autonumber PK. You may be able to adapt this to your situation.

SELECT t.aname, (SELECT COUNT(*)
        FROM Animal AS x
        WHERE x.animalid <= t.animalid
and (((Left([aname],1))="G"))
                        ) AS RowNumber
FROM animal AS t
where (((Left([aname],1))="G"))
ORDER BY t.aname;

Result:

aname	RowNumber
Geronimo	1
GIVPOL	2
GRVYNU	3

[June7]

Review http://allenbrowne.com/ranking.html

[HansBades]

Thank you. I tried that and for the most part it worked but there were always two skus (the same ones) that were in the wrong place every time I ran it. I will figure this out at another time. I am surprised access doesn't have a built in way to do this. Thanks for the tip.