Splitting a table into smaller tables

[joseph g]

I'm trying to split firsttable into smaller tables based on values in
firsttable. no relationships need to be maintained.

FIRSTTABLE
1 green eggs
1 orange eggs
2 green eggs
3 brown ham

so that i end up with
TABLE 1
1 green eggs
1 orange eggs

TABLE 2
2 green eggs

etc. any suggestions?

 

[KARL DEWEY]

any suggestions?
Don't do it.
Why would you need to split?

 

[joseph g]

i'm doing it to take the results as batches and e-mail them to corresponding
facilities/individuals (their id is the first numeral field).

...jg

 

[John W. Vinson]

i'm doing it to take the results as batches and e-mail them to corresponding
facilities/individuals (their id is the first numeral field).

Email a Query instead. There is no need whatsoever to create a whole bunch of
redundant tables!

 

[joseph g]

On Wed, 27 Jan 2010 13:08:02 -0800, joseph g
Email a Query instead. There is no need whatsoever to create a whole bunch of
redundant tables!
--

that makes sense. how do i get the e-mails into batches?
let's say field four has the email address that matches field 1's id.

...jg

 

[John W. Vinson]

that makes sense. how do i get the e-mails into batches?
let's say field four has the email address that matches field 1's id.

Could you please post the fieldnames and relevant information about your
table, and the code you're currently using to email the tables?

 

[joseph g]

Could you please post the fieldnames and relevant information about your
table, and the code you're currently using to email the tables?
--

i have no code, that is why i'm requesting information.
i originally wanted a query that would split my resulting data into separate
tables so i could export the tables into excel for end-users to attach to
e-mails.

 

[KARL DEWEY]

How is your data stored now? Post table and field names with datatype.
Post sample data indicating what would constitute a group of records.

 

[John W. Vinson]

that makes sense. how do i get the e-mails into batches?
let's say field four has the email address that matches field 1's id.

..jg

Create a Query based on your table.

Put

=1

on the Criteria line underneath the ID field (not the email field).

Open this query.

It should show just the one row for employee ID 1.

This query can then be exported.

You can of course do much better, using a parameter query and perhaps some
code to loop through and do the exports... but since you haven't posted any
information about your database, and we don't really know much about your
level of knowledge of the program, it's a bit hard to give specific advice!