Restart number field with 1 for new records for every new date
I have a table in access 2003 where I append records to it using an Append Query, in that table I have a auto number field and other fields such as Test_Date, chart etc. then I have a number field in that same table called Label_Seq , I want that whenever I append records to that table that the value in 'Label_Seq' should start by 1 and increment accordingly for every new value in 'Test_Date'
For example, if I add 5 records where the test date was 9/8/13, 'Label_Seq' should be 1 2 3 4 5, and if I add after that 10 records where the test date was 9/9/13, 'Label_Seq' should be 1 2 3 4 5 6 7 8 9 10, and so on.
So I am looking for the value I should use on 'Label_Seq' when I run the append query to get this accomplished.
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!