I am using an Access database with a VB6 front-end. Does anyone know how I can save the results from a query on a table into a new table so I have just the filtered rows?

Thanks
Tom