We help IT Professionals succeed at work.
Get Started

MS Access - Create Multiple Records based on value in a table

keschuster asked
Last Modified: 2017-03-24
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?
Watch Question
Distinguished Expert 2017
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE