Recent content by Waylen

We have dozens of tables like this that need to be broken out from an old flat table design. We are trying to go to a relational database system but need to break out the data to do so. SQL or any other suggestions would be appreciated. Once again, is this possible?

I need to breakout a bunch of records. My table has 20 fields, for example... Acct, value1, value2, value3, value4, etc... I need to create a new record with the acct field and value1, then I need to create a new record from the same acct and then value2. I have to do this is vba which I've...