SQL Filtering In Access

[tom.exley]

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

[paulw]

Tom,

Just add "INTO NewTable" into your SQL query where NewTable is your new table name.

i.e. use SQL: SELECT Fields INTO NewTable FROM OldTable WHERE etc...

Cheers,

Paul.