Sinced you want to run the query from a button you need to record a
macro while creating the query. The connect a button to the macro.

You either need to have two buttons or put the two queries into a
single macro. The 2nd macro has to be modified so the start location of
the data is put at the end of the 1st query.

Other things that need to be done is to remove the old data before
running the new query and set the query not to automatically update (you
will update using the macro).

Post the recorded macros and we can modify them as necessary. You
possible combine the tow queries into one. the query contains the
"Command Text" which is normally called an SQL. the filtering you are
performing to return only certain data is the "WHERE" portion of the
query. the SQL can be modified to put two "Where" phrases into a single
SQL statement which return all the data in one query instead of two
queries.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=151888

Microsoft Office Help