Changing Multiple Query Criteria.
Posted on 2004-04-01
I have an access database that contains the linked tables. All the tables have the same specifications - they contain standard accounting information for several companies.
My database performs analysis of the information from these linked tables by extracting data for one quarter year at a time. Therefore I have built up a series of append and delete queries, which have all been put into Macros. When the user presses a button the data is all deleted and refreshed. However at present each individual append query need it's criteria updated so that only the relevant quartey year's data is extracted from the tables.
I want to create a button which when clicked asks the user the enter ( once ) the quarter year he's interested in. All the append queries shoudl then be run according to that criteria without manually having to update each and every one separatey. I guess the criteria needs to refer to a dialog box form which runs when the user clicks the button and then the macro needs to be run making sure that it "remembers" that the user has choosen the quarter-year criteria.
Can someone advise please - sorry to be so long- winded, but I'm nervous about playing around with my database now that i've got it to work.