Running Count in Query Field?

[lizlathan]

Howdy gurus,

I need to figure out a way to have a running count in my query so I can add it to an ID field. SOOO easy to do in Excel, but can't figure out for the life of my how to do it in Access.

I have this in the query field:

Field: List: ([enter date format for list code])+"C"
Table:
Total: Group by
Sort:
Show:

and I want to add an running "+1" to the end, so I end up with:
20060321C1
20060321C2
20060321C3
20060321C4
20060321C5

How can I format it to make this happen?

Thanks!
Liz