<div>
I have 107 records. &nbsp;currently should stay that way but could change if they add some more locations to count down the road.
</div>


<div>
Is the ID an incremental number for every record?
</div>


<div>
ID &nbsp; &nbsp; &nbsp;CountNum<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
6 &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
7 &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
8 &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
9 &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
10 &nbsp; &nbsp; &nbsp; 4 &nbsp; etc.
</div>


<div>
<div class="content wysiwyg-content">
I have a table with ID, Locations, CountNum fields. &nbsp;The table has data in the ID and Locations fields.<br />
<br />
I would like to run and query to enter the value 1 in the first 3 records then the number 2 in the next 3 records etc. into the CountNum field.<br />
<br />
Not sure the best way to do this?<br />
<br />
Any suggestions?<br />
<br />
Thanks for your help.
</div>
</div>


I have a table with ID, Locations, CountNum fields.  The table has data in the ID and Locations fields.

I would like to run and query to enter the value 1 in the first 3 records then the number 2 in the next 3 records etc. into the CountNum field.

Not sure the best way to do this?

Any suggestions?

Thanks for your help.

I have 107 records.  currently should stay that way but could change if they add some more locations to count down the road.

Is the ID an incremental number for every record?

ID      CountNum
1         1
2         1
3         1
4         2
5         2
6         2
7         3
8         3
9         3
10       4   etc.

ms access query to group of sequential number in table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.