Manipulating data via VBA - confused...

[steve-oc]

Hi - I have an inherited dataset that needs normalising.

Current Structure: tblAccommodation

PersonID (integer & PK)
13th (boolean)
14th (boolean)
15th (boolean)
and so on until 29th

Sample:
PersonID, 13th, 14th, 15th, 16th, 17th, 18th, etc
1, yes, no, yes, yes, yes, no, yes
2, yes, yes, yes, yes, no, no, no
3, no, yes, yes, yes, no, no, no

How this should be stored (I think) is in a new table with structure:

PersonID (int) (shared PK)
Date (int or date format) (shared PK)

Sample:
PersonID, Date
1, 13
1, 15
1, 16
1, 17
1, 18
2, 13
2, 14
2, 15
2, 16
3, 14
3, 15
3, 16

I'm still very new to visualising how to manipulate data using VBA and DAO recordsets, etc. Do I build two recordsets - and append from one to the other??? Can someone point me in the right direction???

Many thanks
Steve