Hi there,



I have designed a database to keep track of my online trading account. I have a table which adds a new record for each days trading. At the moment i have a field in that table for "starting capital for the day". From this table i have designed a query that works out my total profit/loss for the day and then a calculated field that works out the ending capital for the day ([starting capital] +[profit for the day]).

I am trying to change this so that the starting capital for the day is dragged from the previous day's ending capital without me having to type it in. In the table there is a TradingDayID field which is the primary key and this increases by 1 each day. There must be some simple way of accesing the figure from the query for the previous day's ending capital.

Can anyone help me please?