Need Help Making Multiple Records From One Record

[Rastahl99]

Folks, I need help...I'm stuck. I want to create a Make a Table Query that will create multiple records based upon a number entered in one record field.

Example:

Table 1 (This is my current Table)

Fields -

Widget name Widget Count

Widget 3



Table 2 (The Table I want the query to make)

Widget name Widget Count

Widget 1
Widget 1
Widget 1


Basically the query would take the one record from table 1 and split it into multiple records based upon the number entered in the "Widget Count" field.

PLEASE HELP

 

[dkinley]

You can check out this thread ....

http://www.access-programmers.co.uk/forums/showthread.php?t=157793

The demo there does something like you want and should give you the logic to tweak it to your needs.

-dk

 

[jwhite]

Please explain why you want to do this. Not that I am implying that it is wrong, but it is rare when you would do this (storing redundant data). Normally Queries are used to manipulate data in the manner desired by the users.