Access - Sequence Number reset at each ID exchange

**adgjqetuo** · 11-18-2014, 11:31 PM

I have two tables - one with parent Records, the other with child records. The ID links the two tables together.

I want to add a sequence number on the child table which resets at each ID change. What would be the best way to accomplish this?

Please Login or Register  to view this content.

**MarvinP** · 11-18-2014, 11:52 PM

Hi adgjqetuo,

I'd do this problem using Excel and the Countif function. See the attached for the formula. You should sort the excel sheet to help your numbering and then apply the formulas.

**adgjqetuo** · 11-18-2014, 11:57 PM

Thank you for the reply - I can do it with Excel too, but I was hoping for a solution in Access. I want to automate the process fully through Access and this is the last portion I couldn't figure out.

**alansidman** · 11-19-2014, 01:22 AM

Here is an example and VBA statement to achieve what you are looking for in ACCESS

http://www.blueclaw-db.com/download/...nter_query.htm

Access - Sequence Number reset at each ID exchange

LinkBack

Thread Tools

Rate This Thread

Display

Access - Sequence Number reset at each ID exchange

Re: Access - Sequence Number reset at each ID exchange

Re: Access - Sequence Number reset at each ID exchange

Re: Access - Sequence Number reset at each ID exchange

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sorting the data with Exchange code for different months and paste it in sequence in next

[SOLVED] Need to split letters from number sequence and group value ranges by number

Count A Number Of Times A String Appears but display the number sequence

Exchange a number for a letter forumla

How can I match a random number with closest number from sequence?

Bookmarks

Bookmarks

Posting Permissions