Convert ROW data to COLUMN

[JackP]

I am confused as to what would be the best way to accomplish this... or is
it doable.


Table 1 (Banking) Final resting place for all transactions
Layout
[Date], [Source], [CurrencyType], [Amount]. Source is pulled from the
tblSource with fields like "Till 1 in", "Till 1 Out", "Bank In", "Bank Out"
etc.
and Currency from tblCurrency with fields like "Hundreds", "Fifties",
"Twenties" etc.

Table 2 (TillOut) - This is the records that need to be converted to column
data

This has 5 records in it for the different Till types we use. I have a form
that the user can select the Till Type from a cbo.
[Till Type], [Hundreds], [Fifties], [Twenties], etc.

On that form, I am also pulling the different Sources from Table 3

What I need to do next is put all that together and add new records to Table
1 like this...

' Insert Hundreds
[Date] =now()
[Source] = [from cbo on form]
[CurrencyType] = [form.Hundreds]
[Amount]=[Form.HundredsAmount}]

Next Record

' Insert Fifties
Date] =now()
[Source] = [from cbo on form]
[CurrencyType] = [form.Fifties] <--- notice the change from above.
[Amount]=[Form.FiftysAmount}]

ETC.