Auto Increment Field Using VB?

[susieqtotallynew]

Good day, all,
I have created a query based on an Access Database. I would like to add a numeric field to the query results that automatically increments each item in the results list. Result 1 would have value of 1, result 2 value of 2, etc. It has to be an "automated" solution, meaning that copy and paste, etc., won't be an acceptable solution. Any ideas as to how to best do that? I'm wondering if VB loop is the way to go (if so...suggestions on exactly how to implement would be most appreciated).
Thanks in advance.

 

[SkipVought]

What application?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[susieqtotallynew]

I'm not sure I understand your question...It's a query created in an access database...SQL...

 

[SkipVought]

You originally said, "based in an Access databse." That does not tell me WHERE you are programming.

Asked, you stated, "in an Access database."

That tells me that MS Access is the application.

SELECT A.Col1, (Select Count(*) From TableName Where Col1<A.Col1)+1
FROM TableName A
Order By A.Col1

as an example.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[susieqtotallynew]

Again, I am likely being obtuse, but I have only two columns to work with in the table. One is date, the other is ID. One ID may have many dates. Each ID/Date Listing needs a unique number. In this scenario, which column is Col1?

 

[SkipVought]

Which ever column you sort on.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[susieqtotallynew]

Skip,
Thanks for your help with my questions. I appreciate it.
Susan