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):
  1. Date Opened
  2. Date Closed
  3. Highest Point During Trade
  4. Lowest Point During Trade
  5. Closing Profit/Loss
  6. Total of All Floating Profit/Losses During Trade
Over a period of time, many trades will open and close. At single point in time, there may be one open trade, or many.

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!