All,
I'm trying to make Access work like XL, creating data on new rows based on prior rows.
Sort of like an accounting system
Best to give an example. See the attached spreadsheet
I will have Columns A - E in the Table
Column F values are what I need to create. See the formulas.
A few things to note.
1) The data will be sorted by Account ID, Security ID, Position_Date
2) The Combination of Position Date, Account_ID and Security ID is unique
3) Yellow notes the start of each new Account and Security ID
I'm sure this is a code thing... So I'm a little out of my element.
I really appreciate the help
I'm trying to make Access work like XL, creating data on new rows based on prior rows.
Sort of like an accounting system
Best to give an example. See the attached spreadsheet
I will have Columns A - E in the Table
Column F values are what I need to create. See the formulas.
A few things to note.
1) The data will be sorted by Account ID, Security ID, Position_Date
2) The Combination of Position Date, Account_ID and Security ID is unique
3) Yellow notes the start of each new Account and Security ID
I'm sure this is a code thing... So I'm a little out of my element.
I really appreciate the help