Solved

Copy Rows in Access Table

Posted on 2012-03-15
6
234 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

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
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

624 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