Splitting a table into smaller tables

  • Thread starter Thread starter joseph g
  • Start date Start date
J

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?
 
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
 
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).
Click to expand...

Email a Query instead. There is no need whatsoever to create a whole bunch of
redundant tables!
 
John W. Vinson said:
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!
--
Click to expand...

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
 
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.
Click to expand...

Could you please post the fieldnames and relevant information about your
table, and the code you're currently using to email the tables?
 
John W. Vinson said:
Could you please post the fieldnames and relevant information about your
table, and the code you're currently using to email the tables?
--
Click to expand...

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.
 
How is your data stored now? Post table and field names with datatype.
Post sample data indicating what would constitute a group of records.
 
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
Click to expand...

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!
 
Back
Top