Information Recovery - what if......

[Solaron]

i have come across a serious design flaw in my database.

It consists of takings from vending machines which are updated every month. I'm sure there may be similar posts like this on this forum so apologies if this has come up already.

WHat happens is that i have written a query that will go through all the information about takings at the end of each month and reset them all back to zero. The only backup needed is a simple export to an excel spreadsheet for reference purposes, BUT that has to be done manually.

How do i get it so when they click on the button for the query to reset the information, it automatically exports the information into an spreadsheet (or something similar)

many thanks,

Chris

 

[Pat Hartman]

You are presently running update queries from code or from a macro to do the reset process. Just add a TransferSpreadsheet step ahead of the reset process.

 

[Solaron]

Cheers guys, i've managed to get what i wanted now - all works good.

 

[Solaron]

Not quite so all good!

Well, i take that back. I have managed to do it APART from the filename. I know you can specify a filename, but i want to be able to have the days date as the filename to export to. Any ideas?