Access Table

%3CLINGO-SUB%20id%3D%22lingo-sub-967068%22%20slang%3D%22en-US%22%3EAccess%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-967068%22%20slang%3D%22en-US%22%3E%3CP%3EI%20track%20the%20value%20of%20several%20stocks%20each%20week.%26nbsp%3B%20I%20have%20a%20table%20which%20includes%20Client%20ID%2C%20Stock%20ID%2C%20Week%20Date%2C%20Number%20of%20Shares%20and%20Stock%20Price%20(from%20another%20table).%3C%2FP%3E%3CP%3EI%20want%20the%20table%20to%20have%20a%20an%20added%20record%20(line%20item)%20each%20week%20so%20I%20can%20calculate%20Rates%20of%20Return%20for%20several%20different%20time%20periods.%3C%2FP%3E%3CP%3EI%20have%20built%20the%20query%20that%20provides%20all%20the%20information%2C%20but%20I%20would%20like%20to%20have%20Access%20automatically%20generate%20the%20new%20record%20each%20week.%3C%2FP%3E%3CP%3EAny%20ideas%3F%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-967068%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995203%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F436799%22%20target%3D%22_blank%22%3E%40Jophant%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20am%20correctly%20a%20query%20gives%20the%20information%20for%20you%3F%3C%2FP%3E%3CP%3EThen%20create%20a%20query%20or%20edit%20your%20existing%20query%20for%20inserting%20the%20values%20into%20a%20table.%20To%20make%20it%20more%20fancy%20you%20can%20build%20a%20form%20with%20an%20event%20like%20onload%2C%20what%20is%20checking%20out%20if%20the%20insert%20is%20done%20for%20that%20week%20and%20if%20not%20then%20do%20it.%20Even%20possible%20to%20do%20that%20with%20several%20weeks%20in%20one%20time%20if%20you%20did%20not%20use%20the%20database%20for%20more%20then%20a%20week%20%3B)%3C%2Fimg%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccess%20can%20do%20almost%20anything%20%3A))%26nbsp%3B%20Just%20develop%20your%20skills%20and%20enjoy%20the%20possibillities%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

I track the value of several stocks each week.  I have a table which includes Client ID, Stock ID, Week Date, Number of Shares and Stock Price (from another table).

I want the table to have a an added record (line item) each week so I can calculate Rates of Return for several different time periods.

I have built the query that provides all the information, but I would like to have Access automatically generate the new record each week.

Any ideas?  Thanks.

1 Reply
Highlighted

@Jophant 

 

If I am correctly a query gives the information for you?

Then create a query or edit your existing query for inserting the values into a table. To make it more fancy you can build a form with an event like onload, what is checking out if the insert is done for that week and if not then do it. Even possible to do that with several weeks in one time if you did not use the database for more then a week ;)  

 

Access can do almost anything :))  Just develop your skills and enjoy the possibillities