A
argear
I'm trying to write an update query to add a record number to a group of
records.
The table looks like this:
ID Name Date Day
1 Jane 1/1/07
1 Jane 1/2/07
2 John 1/5/07
I'm trying to update the "Day" field where the count starts over for each
new ID number at 1 and then runs sequentially. Can anyone help?
records.
The table looks like this:
ID Name Date Day
1 Jane 1/1/07
1 Jane 1/2/07
2 John 1/5/07
I'm trying to update the "Day" field where the count starts over for each
new ID number at 1 and then runs sequentially. Can anyone help?