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

Need to update table linked to a report

P: 1
I run a daily Make Table Query and want to generate a report based on the resulting table. When I run the Make Table Query each day, it must delete the table before rebuilding each day. As long as that table is connected to the report, the query can't delete it.

I simply want to update the table so I can use it in a daily flash report, but I must update the table daily. My current method of trying to use the Make Table Query won't allow that.
Dec 28 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,660
I run a daily Make Table Query and want to generate a report based on the resulting table. When I run the Make Table Query each day, it must delete the table before rebuilding each day. As long as that table is connected to the report, the query can't delete it.

I simply want to update the table so I can use it in a daily flash report, but I must update the table daily. My current method of trying to use the Make Table Query won't allow that.
Instead of doing a Make Table query, do an Append query.
First you need to clear the existing data...
Expand|Select|Wrap|Line Numbers
  1. DELETE FROM [YourTable]
Then you simply run the same append query into the same table.
Dec 30 '06 #2

Post your reply

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