Calculating Net Change

[Guest]

I am fairly new to access programming. I have created a database of stocks
and want to add a column for net change.
The logic is today's close minus the close of yesterday. I would also like
to add flexibility to get the net change of any time period.

My columns now include date and close.

 

[Rick B]

Your "columns" now include date and close?

This would not be normalized database design. This is a many-to-many or at
the very least a one-to-many relationship. You should have a new table with
fields like: symbol, date, close. For each date and stock symbol , you
would add a new record to the table.

Once you get that done, then you would need to be able to build a query or a
report or a form to pull in two dates for a given symbol and calculate the
difference. How you would accomplish that would require you to give us more
details about what you need to obtain.

Rick B