424,279 Members | 1,907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,279 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,
6 Days Ago #1
Share this Question
Share on Google+
5 Replies


PhilOfWalton
Expert 100+
P: 1,424
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
5 Days Ago #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
5 Days Ago #3

PhilOfWalton
Expert 100+
P: 1,424
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
5 Days Ago #4

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

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

Phil
5 Days Ago #6

Post your reply

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