Combining Queries

[Jon]

Hi,
This is a follow on question (but different thread) from earlier today.
I import employee overtime records from a spreadsheet that is produced twice
each week, covering a rolling 2 week period, into a single table in my db.
It includes records from other units which I'm not interested in. Also, as
there is this rolling 2 week period, I end up with duplicate records, which
I identify and delete. Lastly I update a "week ending "date field.
I have 3 queries as follows:
Query 1 - deletes records which are not related to the unit I work in
Query 2 - identifies duplicate records and deletes them
Query 3 - updates the "Week Ending" field on the remaining new records
I'd like to have a routine that will run these queries one after another
(obviously once the previous one has completed). How do I do this???
TIA
Jon

 

[bhicks11 via AccessMonster.com]

You can do it in a macro or VBA, one after another. You can even do a macro
and save it as a module (VBA). In a macro you use the OpenQuery command and
in VBA you would use the DoCmd.OpenQuery command.

Bonnie
http://www.dataplus-svc.com