550 reputation
823
bio website
location
age
visits member for 2 years, 1 month
seen Apr 1 at 0:11

Mar
27
awarded  Notable Question
Mar
18
awarded  Tumbleweed
Mar
14
awarded  Popular Question
Mar
13
awarded  Yearling
Mar
11
asked Is it possible to have 1 piece of code do Global Error Catching in Access 2007 VBA
Feb
19
awarded  Popular Question
Feb
16
comment Rearranging Data in an MS Access 2007 table into a new table format/Result Output
Thank you! I had already used the previous answer to convert my tables but I was able to use your code to Union all 50 tables without having to write out all the code manually! Save me a lot of time! Thankas again!
Feb
5
comment Rearranging Data in an MS Access 2007 table into a new table format/Result Output
Works Great! Since I have about 50 tables I'm going to try to have a vba or sql script output the code for me for all the different tables by bringing the column names (since they are different) but the code you have provided me will save me A TON of TIME! Thank you.
Feb
5
accepted Rearranging Data in an MS Access 2007 table into a new table format/Result Output
Jan
30
revised Rearranging Data in an MS Access 2007 table into a new table format/Result Output
deleted 28 characters in body; edited title
Jan
30
revised Rearranging Data in an MS Access 2007 table into a new table format/Result Output
added 1 characters in body
Jan
30
revised Rearranging Data in an MS Access 2007 table into a new table format/Result Output
added 253 characters in body
Jan
30
comment Rearranging Data in an MS Access 2007 table into a new table format/Result Output
@Colin'tHart I have close to 50 tables So I will need to find a solution that I can apply to all the other tables (even if I have to run the solution once for each table). If I can find a way to convert/output the data in my example above into the new format, then I can go from there. I am reading into the TRANSFORM command you mentioned. It might be just what I need. I'll post back. Thanks!
Jan
30
comment Rearranging Data in an MS Access 2007 table into a new table format/Result Output
@ypercube Done. The answer should be for Access. When I mentioned SQL in the original question I meant SQL code in an Access query (SQL view) or VBA solution. All my tables do not have the same number of columns or names but If I can figure out how to convert 1 table (above example) to the new format, I will be able to continue from there (even if i have to modify the code to work for the other tables). Thanks!
Jan
30
awarded  Promoter
Jan
30
revised Rearranging Data in an MS Access 2007 table into a new table format/Result Output
deleted 306 characters in body; edited title
Jan
30
revised Rearranging Data in an MS Access 2007 table into a new table format/Result Output
deleted 306 characters in body; edited title
Jan
29
comment VBA Maximize Access Application Main Window
@MATTYZDBA Thanks!
Jan
28
revised VBA Maximize Access Application Main Window
added 273 characters in body
Jan
28
asked VBA Maximize Access Application Main Window