Count of equal item in a set

[Thompyt]

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.

X=0
For X=X+1
Code
Next X

If I make this query for the attached Access db: Counting4.accdb

SELECT Data.Platform, Data.LinName, Data.SequenceFROM Data
WHERE (((Data.LIN)="XXB804"))
ORDER BY Data.Platform;;

I get:
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

[June7]

That isn't just calculating a count - a simple aggregate GROUP BY query could do that. What you show is a sequence identifier, AKA row number - not easy to do in query.

Not sure what level you want to do the sequence count. According to data in table, each platform can have multiple LINName values. Your posted example does not reflect that.

Could generate it in a report using textbox RunningSum property.

A query could use DCount(), like:

SELECT Data.Platform, Data.LinName, DCount("*","Data","Platform='" & [Platform] & "' AND LinName='" & [LinName] & "' AND ID<" & [ID])+1 AS Seq
FROM Data
ORDER BY Data.Platform, Data.LinName, DCount("*","Data","Platform='" & [Platform] & "' AND LinName='" & [LinName] & "' AND ID<" & [ID])+1;

[Thompyt]

June7,
Thanks, Now I have to figure out what the code is doing. What you did was the first step.

I modified it to look at the Parent and count. This it counts all the 117s, then counts all the 155's on the platform, then count the channel number assigned to the 155's

DCount("Unique","Data","Parent='" & [Parent] & "' AND Lin='" & [Lin] & "' AND ID<" & [ID])+1

Thanks!!