Query not working after recreating Table

[Firasath]

Hi,

I have to maintain a Month-To-Date complaints dump that will import in to Access on daily basis. I have created a Query with calculated columns based on that Table to calculate the various KPIs which is working fine. Now the problem I'm facing is when I try to import and overwrite the Table with the same name, the query is not working. It is asking to refer the values of the fields.

I tried linking the table, and it worked fine. But is is making the Access very slow.

How can I update the table with updated MTD data on daily basis without disturbing the Query.

Kindly advise.

 

[Firasath]

Dear, I need support on thread http://www.mrexcel.com/forum/microsoft-access/887104-accumulated-values-query.html .

 

[Joe4]

Facing some other issues for which raised two more threads separately. If you could please have a look on the recent one and advise.

Dear, I need support on thread Accumulated values in query .

No need to do this. If I am on-line, see an unanswered question that I feel I can help with, I will reply.
If I don't reply, I am probably not on-line or unable to help.