By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 858 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Assign value series sequentially

P: 1
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.
Jan 12 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
For this I would use Recordset programming. You'll need to use logic in your code to balance the data as you need.
Jan 12 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.