Queries showing Beginning Balance & Ending Balance

[Fred Chow]

Hi all,

Suppose I have an inventory table listing all stock transactions such as
stock code, transaction date, and transaction amount (positive for stock in;
negative for stock out).

Now I want to construct a total queries showing, showing the beginning and
ending balance of each stock of every month. Note that in general the
beginning balance of a month is equal to the ending balance of the previous
month. How can I make the beginning balance column and the ending balance
column in the queries? Please advise.

Frederick Chow
Hong Kong.