Suppose I have a database of 10,000 historical stock trades with the following field names: (there are more names but these are enough for this question):Over a period of time, many trades will open and close. At single point in time, there may be one open trade, or many.
- Date Opened
- Date Closed
- Highest Point During Trade
- Lowest Point During Trade
- Closing Profit/Loss
- Total of All Floating Profit/Losses During Trade
Suppose at noon on 7/15/09 there were three open trades (A,B and C), and one trade (D) which just closed.
I want field 6 to = the sum of field 4 for trades A,B,C, and D. (In other words, I want to see the lowest possible account balance during the "life" of trade D)
If it will help I'll upload a small file. Consider me at the "idiot level" with Access. I've only used it a few times.
Thanks!