Calculating Net Change

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top