Assign value series sequentially

[C Jones]

I receive a number of daily additions to a table (t1), and am trying to assign values from another table (t2) sequentially, and repeat the sequence as many times as necessary to fill the field.

Each record is unique but not sequentially numbered.
The number of values from (t2) can change from day to day

so for records 1,2....10 I have values a,b,c that I would like to make the output:
1 a
2 b
3 c
4 a
5 b
6 c
7 a
8 b
9 c
10 a

I started trying to work it out with autonumbering, the count function, and the mod function, but I can't seem to get it to work at all.

[NeoPa]

For this I would use Recordset programming. You'll need to use logic in your code to balance the data as you need.