Create Records with Range

[WildMan]

VBA coding help!

I have a table called Control_Id.

In the table, I have three fields.

Control_ID
BegBates
EndBates

An example record would be as follows:

Control_ID =00000001
BegBates = DB 000001
EndBates = DB 000007

Somehow, I need to make new records for this one record. I really could care less about the Control_ID field, since the data is useless.

I need the end results to be as follows, pulling all the BegBates and EndBates into the table for this record.
DB 000001
DB 000002
DB 000003
DB 000004
DB 000005
DB 000006
DB 000007

Please help!

Thanks!

 

[Mile-O]

One question first: why? I only ask because you may just be overcomplicating things and there may be a simpler solution.

 

[aaron.orrell]

I have a table called Control_Id.

In the table, I have three fields.

Control_ID
BegBates
EndBates

An example record would be as follows:

Control_ID =00000001
BegBates = DB 000001
EndBates = DB 000007

Somehow, I need to make new records for this one record. I really could care less about the Control_ID field, since the data is useless.

I need the end results to be as follows, pulling all the BegBates and EndBates into the table for this record.
DB 000001
DB 000002
DB 000003
DB 000004
DB 000005
DB 000006
DB 000007

Please help!

Thanks!

I think your answer may be in the post by FRIDAY titled "Insert New Records with Range of Values"

 

[bkitka]

I think your answer may be in the post by FRIDAY titled "Insert New Records with Range of Values"

I have the same issue. I cannot find the post that you mentioned that might have the solution.

 

[Jon K]

Friday's post:
http://www.access-programmers.co.uk/forums/showthread.php?t=63687