How 2 make a table from VBA code?

[Shawnus-Maximus]

What I have:

tblFlocks-(pk)FlockID, FlockName, BirdQty, DateLay, EggStd

tblEggStd-(pk)EggStdId, EggStdName

tblEggStdSub-(pk)(EggStdId, EggStdName, WeekOfLay),Std

What I need (I think, am open to suggestions):

I need to have for each FlockId the number of eggs produced during each of the 28 weeks that the flock will be laying eggs. If I can loop DateLay+7 to get 28 fields in a new table, and loop Std(double) by WeekOfLay (integer,1-28) into those 28 date fields. then use a query to multiply the Std by BirdQty, I can get the eggs by date.?

Then all FlockId would need to be on one report with their eggs by date.

I do not know how to make the table with loops and then fill it with Stds in the right date. Any Ideas?

Thanks,
Shawn