Here's what I'm essentially trying to accomplish:
yr month nbr
2011 january 1
2011 february 2
2011 june 6
2012 february 2
2012 august 8
2012 december 12
2012 november 11
What I want the query results to show:
yr mo1 nbr1 mo2 nbr2 mo3 nbr3 mo4 nbr4
2011 january 1 february 2 june 6
2012 february 2 august 8 december 12 november 11
My table will have anywhere from one row per ID (in this case year) to fifteen. I doubt this is possible without VBA, but maybe someone can enlighten me. I'm attaching a copy of my actual tables (MS Access 2007 ACCDB format) if a VB solution is required. (tblAwardsAll is the table that I need to accomplish this with-SSNs have been modified and last4's scrambled)
If VB is required and it is to make a table, it will need to overwrite/delete the existing table each time it is run. Also, it needs to be able to function as an ACCDE. I'm unsure if there are any limitations to creating/deleting tables via VBA using this locked format.
Thanks in advance for the help! I can do simple tasks in VBA but this is over my head.