I have a thread in the Query part of the site - https://www.accessforums.net/showthread.php?t=69823
I think this needs to be done in VBA.
I need to count of the number of times LIN=XXB804 in each platform.
If I make this query for the attached Access db: Counting4.accdbCode:X=0 For X=X+1 Code Next X
I get:Code:SELECT Data.Platform, Data.LinName, Data.SequenceFROM Data WHERE (((Data.LIN)="XXB804")) ORDER BY Data.Platform;;
Platform..LINName..Sequence
11321.....VRC-117
11321.....VRC-117
11321.....VRC-117
12321.....VRC-117
How do I get the sequence field filled in as:
Platform..LINName..Sequence
11321.....VRC-117...1
11321.....VRC-117...2
11321.....VRC-117...3
12321.....VRC-117...1