Hi, using Access-2016. I have a table in which I need to perform a query to add a grouping number. First table (TblData) which includes Tag and a Plaza.
I want to create a query which groups the like tag numbers until a new tag starts, however if the tag repeats later in the data it will group it as a new group number.
Final results TblFinalQueryResults
assigning numbers.accdb
Thanks so much for the help!!