write a Select query to pull the specific records you need. once the query
is returning the appropriate records, turn the query into an Append query to
add those records to an existing table, or turn the query into a Make-Table
query to create a new table holding the records. see Access Help for details
on both types of action queries.
to run a query from a macro, use the OpenQuery action. to suppress the
automatic warning before records are added, precede the OpenQuery action
with a SetWarnings action.
hth
