If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating Net Change
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. |
#2
|
|||
|
|||
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 "Needhelp1" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | RICHARD | Worksheet Functions | 1 | March 15th, 2005 05:49 PM |
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | RICHARD | General Discussion | 0 | March 1st, 2005 01:53 PM |
Change value for multiple columns? | MN | Running & Setting Up Queries | 8 | October 22nd, 2004 03:11 PM |
change regional Settings To UK currency format from a shared hosting server in Germany... | Edward | General Discussion | 1 | September 19th, 2004 11:36 AM |
A change of track changes | Lorrie | Formatting Long Documents | 1 | June 12th, 2004 02:32 AM |