mato01
asked on
Copy Rows in Access Table
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.
Can you upload your table and expected result?
ASKER
Per your request. Here is a sample.
Sample-Table.xlsx
Sample-Table.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
als315,
You are always on top of your game!
;-)
Jeff
You are always on top of your game!
;-)
Jeff
<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
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
ASKER
Worked perfectly in my scenario. Thanks a lot.