I have created an ODBC link to one of our tables from our accounting system.
I have 3 fields in this table:
-amount (this field consists of 12 subfields for each month. The months are separated by '; ' ).
How do i update this table so it has 4 fields
I know how to separate the amount - subfield(amount, ";" ), but i don't know how to create a new field for month. That is, the first subfield will have a month of January, the second subfield will have a month of February etc.