I would think the BEST way is to add a new column into the source
database which indicates the specific part you are looking for. Then
filter on the new column to get your specific parts.

If this is not posiblle then you need to add a "WHERE" clause into your
SQL to pull only the parts you are looking for. If you are doing a
query the "WHERE" is the command portion of the SQL. The Query Wizard
can enter a "Where" clause but not when it is 100 itmes.

If you want a query I would recommend recording a macro and then modify
the recorded macro to add the addition items. If you record the macro I
can make the modifications to add more fields into the where clause.

Another method would to be retrieve all the data in a query. You can
use a "Query Update" event to process the returned data moving only the
items you need to a different worksheet.


--
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=151847

Microsoft Office Help