Home

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
Jophant
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

@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 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies