I have a table with a very large number of records, I want to query a field in this table with one action to make four new tables

table 1 to have
12**
13**
4***
5***
8***

table 2 to have
14**
2***
6***

table 3 to have
3***

and table 4 to have
7***

(where * is all numbers between 0 - 9)

is this posible?

thanks,
Murley http://www.access-programmers.co.uk/ubb/smile.gif

Why make new tables? Why not just filter your table in a query?
Make four queries and assign each one the specific criteria you need. Then your data stays in one place but you can view it more manageably.

Good luck,
David R

I need the criteria for each table outputed to 4 excel speedsheets,
can I still do this with four queries ?

p.s. sorry I'm new to access.

Murley http://www.access-programmers.co.uk/ubb/smile.gif

Try it?
I don't work with exporting data to Excel myself, but other posters have said they do it all the time. A few had problems, so post back if it gives you fits.
Search the archives for 'export query to excel' for more assistance on a variety of varieties of this action.

Good luck,
David R

Export the query to Excel rather than the underlying table.