Solved

Copy Rows in Access Table

Posted on 2012-03-15
6
230 Views
Last Modified: 2012-03-16
I have a access table with rows with a month (DEC) in Column C.  I need to copy each row to months JAN through NOV.  So I then have all the data JAN through DEC.
0
Comment
Question by:mato01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 40

Expert Comment

by:als315
ID: 37727886
Can you upload your table and expected result?
0
 

Author Comment

by:mato01
ID: 37727912
Per your request.  Here is a sample.
Sample-Table.xlsx
0
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 37728000
Check DB.
You should have index in table (PRODUCTS+YEAR+MONTH)
DBcopyrows.mdb
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37729462
als315,

You are always on top of your game!

;-)

Jeff
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37729508
<No Points wanted.>

The beauty of als315's solution is that all you have to do is maintain a table with your months.
;-)


One note though, you may want to start using the Month "Value"(1-12) instead of the Name (String).

This is so that you can eventually:
Combine the data values into a real date
Do calculations with these values.
(DateDiff, ...etc)
...etc

You can easily display the Name while referencing the number
MonthName(MonthValue)

;-)

JeffCoachman
0
 

Author Closing Comment

by:mato01
ID: 37730441
Worked perfectly in my scenario.  Thanks a lot.
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question