Need to update table linked to a report

[colpac]

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.

[NeoPa]

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

DELETE FROM [YourTable]

Then you simply run the same append query into the same table.