troubleshooting Question

Restart number field with 1 for new records for every new date

Avatar of JohnTall
JohnTallFlag for Afghanistan asked on
Microsoft AccessSQL
31 Comments1 Solution475 ViewsLast Modified:
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.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 31 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 31 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros