Counter based on data category

[CJ_London]

but it appears that these are on a form

so you didn't look at the underlying queries then?



You do realise that by providing incomplete information, wrong answers to clarification questions and simplistic sample data, you are wasting everyone's time, including your own.

Suggest since this is to be exported to excel and you have an excel solution for your requirement you stick with that. Google 'excel automation from access' if you don't know how to do this from Access, or just do it manually

[NoellaG]

I wouldn't use domain functions in queries, they are deadly for performance. But something like rownumber() over (partion by [grouping field] order by [ordering field]). Only, I don't know the Access syntax for this.

[señor_sriracha]

=IF(B2=B1,A1+1,1)

This will only count sequential instances of a value. If the value is repeated again a few lines later the count starts over at 1.
That makes it highly dependent on the order the records are displayed.

[Welshgasman]

This will only count sequential instances of a value. If the value is repeated again a few lines later the count starts over at 1.
That makes it highly dependent on the order the records are displayed.

That is what we are trying to get over to the O/P.
CJ_London has supplied a link to a DB that has a function to do what the O/P wants, but it still has to be in a certain order for even that to work.

[chudok01]

This will only count sequential instances of a value. If the value is repeated again a few lines later the count starts over at 1.
That makes it highly dependent on the order the records are displayed.

I am ok with that. The data is already sorted in the way I need it sorted for this numbering I need.

[NoellaG]

To have it in a query without using a form:



Only I don't know how to convert to pure Access SQL.