Sometimes the simplest sounding things get me stuck

[NYFashionToGo]

I have action queries that I run daily (sometimes more than once daily) right now I need to add a number to each line, for each record. First row = 1, 2nd =2 , 3rd =3.. why cant I figure this out.......... Does anyone know how I can achieve this... every time it can start with 1. I am stumpted.. Please advise. Thanks

 

[cmmrfrds]

In Access you can create a query and then join that query to a table. If the table has a unique ID then the table can be self joined to create a row number.

For instance, assume the table has a unique column called name.
SELECT Count(*) AS row, A.name
FROM [NameTable] AS A, [NameTable] AS B
WHERE A.name >= B.name
GROUP BY A.name;
Save this as a query, say called NameRank.

Now you can join this query to a table say called NameTable with a unique id of name.

Select
name,
row
From NameTable as A
Inner Join NameRank as B
On B.name = A.name