Solved

Copy Rows in Access Table

Posted on 2012-03-15
6
226 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
  • 2
  • 2
  • 2
6 Comments
 
LVL 39

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 39

Accepted Solution

by:
als315 earned 500 total points
ID: 37728000
Check DB.
You should have index in table (PRODUCTS+YEAR+MONTH)
DBcopyrows.mdb
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

808 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