By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 1,571 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

Is it possible to dump a linked table into a local and update automatically

anoble1
100+
P: 223
I am having trouble with a linked table. Is there a way to dump this linked table into a local table and have it Append records when new ones are added nightly or whenever?
I need a local table so I can add a calculated field in the local table so I can filter in a query a percentage margin. This seems to be the only way. Not sure how to update automatically though from Linked to Local New Table.


Thanks,
Feb 13 '19 #1
Share this Question
Share on Google+
5 Replies


PhilOfWalton
Expert 100+
P: 1,430
Two points.

1) It is bad practice to store a calculated field in a table. (see articles about database normalisation).
If you can do the calculation, it is simple to create a query based on your table, and just add the calculated field to the query.

2) Do you intend to update the linked table to match the updated local table?

Phil
Feb 13 '19 #2

anoble1
100+
P: 223
Yeah I intend to update the table to match maybe 2-3 times a month.
I canít put in the query because my calculation has criteria that I need to limit based on that calculation. Stinks
Feb 13 '19 #3

PhilOfWalton
Expert 100+
P: 1,430
Sorry,
I canít put in the query because my calculation has criteria that I need to limit based on that calculation
makes no sense to me at all. Please rephrase this

Where are you getting the Criteria from?

Can you please give an example of your table and the calculations you use to give you the margin?

Phil
Feb 13 '19 #4

anoble1
100+
P: 223
Here is the thread from last time. Thanks Phil
https://bytes.com/topic/access/answe...la-field-query
Feb 14 '19 #5

PhilOfWalton
Expert 100+
P: 1,430
Please answer the questions. The link does not help in the slightest.

Phil
Feb 14 '19 #6

Post your reply

Sign in to post your reply or Sign up for a free account.