Creating Records in New Table Using a Loop

[Cathy]

I have a table where each record has a quantity. (ie. Item ABC has a qty =
4) I need to create a loop that will create 4 records with each having a qty
of 1 in a new table. How would I go about doing this? (Please make your
responce for a newbie to VBA.)

Thank you!
Cathy

 

[dch3]

Can you share the bigger picture? What is the specific need to create a 4
separate records? Do you have a record in one table with related records in
another into which the four will be inserted?

 

[Cathy]

At a high level, I need to compare plan data to actual over time and show
early, late, and on-time. My plan records are summarized. My actual records
are individual. I'm having a hard time comparing the following information
without breaking down the plan information.

Plan:
1/1/2008 = 4
1/2/2008 = 1
1/3/2008 = 5

Actual:
1/1/2008 = 1
1/1/2008 = 1
1/1/2008 = 1
1/2/2008 = 1
1/2/2008 = 1
1/3/2008 = 1
1/3/2008 = 1
1/3/2008 = 1
1/3/2008 = 1

How many records were early, late, and on-time? The only way I can think to
do it is break the plan down into individual records and run matching
routines, then compare the results.

If you have a better solution, I would be very interested to hear it!

Thank you,
Cathy

 

[Chris O''''Neill]

I'm not a VB/VBA expert so others will have to help you on the technical
side, but in general terms what you're contemplating (processing the "plan"
records in order to compare them with the "actual" recordsl) doesn't sound
like "a good idea" to me. Rather, if anything, you should be processing the
detailed records (summarising them in some way???).

In the "plan" records, what constitutes early, late and on-time? If it's a
planned date and/or time, then you "should" be able to parse through each
"actual" record and compare it to the date/time deadline criteria set out in
the "plan" record . That would tell you whether each "actual" record was
early, late, or on-time. Then, it would just be a matter of totally up the
each category.

Or, maybe I'm not fully understanding what you're trying to do? Perhaps
more info would help? What fields do you have in the "plan" records? What
fields are in the "actual" records? What, specifically, are you trying to
compare?

Sorry I'm not providing answers, but sometimes it's better to focus on
questions rather than answers.

Regards, Chris