Hey all - Looking for ideas on how to accomplish this. I have the table below in Access. For every location I need to create a records in a table equal to the value of source count. The table below is a query result
Location1 get two records created
Location 2 gets five records created
Location Description SourceCount
Location1 60# Washers 2
Location2 LG/SQ Horizon Front Loads 5
Location3 27# / 30# Washers 9
Location4 S-20# Washers 8
Location5 25# Washers 4
Location6 27# / 30# Washers 2
Location7 LG/SQ Horizon Front Loads 12
Location8 horizon 3
Any suggestions?
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.