I have a databse that tracks collection activity. It consists of 3 tables (tblCustomer, tblCollection, and tblAmount). I use one form to enter data, and a second form (based on a querry) to append and delete the accounts. We would like to be able to track statistical info over the course of the year (quarterly, year end etc) as well as find out if the same accounts are coming up for collection repeatedly. I created an append querry that will store the info in a fourth table (tblArchive). Every time I run the querry, it adds all the current info, even if it is a duplicate. If I cahnge the querry to a MakeTable querry, it deletes the table every time it runs. If I leave the querry as an append querry, then create a find duplicates querry, I get a 2nd table with all the dups. If I convert this to a delete querry, it takes out all of the dups, and the originals, thereby leaving me with only the single entries - which are really all the deleted accounts.
How can I make a table that will record all of the accounts, regardless of if they get deleted. Kind of a snapshot of every account that has been entered throughout the year. The next part is how do I get it to run automatically so that all activity will be recorded without relying on the human factor???
I know I am close, but missing something....thanks for the help.
How can I make a table that will record all of the accounts, regardless of if they get deleted. Kind of a snapshot of every account that has been entered throughout the year. The next part is how do I get it to run automatically so that all activity will be recorded without relying on the human factor???
I know I am close, but missing something....thanks for the help.