Gasman
Enthusiastic Amateur
- Local time
- Today, 09:23
- Joined
- Sep 21, 2011
- Messages
- 14,350
Hi all,
I am creating a database to replace an Excel workbook I created a short while back.
It tracks commission payments, and at present the % is set.
However I was thinking that would likely change, and have been informed today that it will.
Therefore I need to keep track of the % during a particular period.
I realise that I would need at least
ID - PK
SubmitterID - FK
Rate - %
EffectiveDate -
but unsure on how I would then process this table via queries, or would I need VBA to find what %ge I would need to apply to a trade which is after or before an effective date for the above.
Data will be exported to Excel probably for ease of use by the recipients.
At present each trade shows it's respective commission and whether paid or not.
TIA
I am creating a database to replace an Excel workbook I created a short while back.
It tracks commission payments, and at present the % is set.
However I was thinking that would likely change, and have been informed today that it will.
Therefore I need to keep track of the % during a particular period.
I realise that I would need at least
ID - PK
SubmitterID - FK
Rate - %
EffectiveDate -
but unsure on how I would then process this table via queries, or would I need VBA to find what %ge I would need to apply to a trade which is after or before an effective date for the above.
Data will be exported to Excel probably for ease of use by the recipients.
At present each trade shows it's respective commission and whether paid or not.
TIA