Splitting a table into 4 tables???????

[Toby1kenobe]

Hi

I need to split a table which holds 40 records into 4 smaller tables. This will allow me to make 4 charts instead of 1. I've thought of using queries but i'm not sure of how to set the criteria

Any help as always is greatly appreciated
Toby

 

[hermanlaksko]

Whey not base the charts on a recordset from this single tbl.
Make a select statement something like this:

"Select * From YrTbl Where YrSelFld=" & Chart1

This should do the trick
Rgds
Herman

 

[beetee]

You likely want to use queries.

You can split records up using queries in two ways:
1) Use select criteria to show different records
2) Specify different sets of columns (fields) in the query.

 

[Toby1kenobe]

Thanks for the speedy responses

is there a way using queries to select 'the first 10' values from my table, then 'values 11 thro' 20, etc?

Toby

 

[flyboytim]

If you have an index field, i.e. one that has a value of "1" for the first record, and "40" for the last, and all the numbers in between, it is easy.
You need 4 queries:

Query1-10
SELECT Table.*
FROM

WHERE (((Table.index)<=10));

Query11-20
SELECT Table.*
FROM

WHERE (((Table.index)BETWEEN 11 AND 20));

Query21-30
SELECT Table.*
FROM

WHERE (((Table.index)BETWEEN 21 AND 30));

Query31-40
SELECT Table.*
FROM

WHERE (((Table.index)BETWEEN 31 AND 40));

ok?