R
Randi
I have basically taught myself Access on Access 2.0. I
haven't done a very good job, though, so here is my
question...
For my work, I have a database that I wish to use over and
over for different counties in the state. There are two
tables for each county, that I query to produce the
necessary mini reports. In addition, I have a mail merge
document that I use to generate my large report, which is
3 pages long. I set up the queries, form, reports, and
mail merge document based on a particular county. Now I
wish to use the tables from another county in the database
without keeping the original county's tables there. Is
there a way to make my existing database and mail merge
document more generic so that I can easily switch from one
county to the other? (The tables for each county always
have the same number and names of fields with the same
primary key.)
I'm not sure if I wrote this correctly, but hopefully
someone will have some advice!
Thank You!
Randi
haven't done a very good job, though, so here is my
question...
For my work, I have a database that I wish to use over and
over for different counties in the state. There are two
tables for each county, that I query to produce the
necessary mini reports. In addition, I have a mail merge
document that I use to generate my large report, which is
3 pages long. I set up the queries, form, reports, and
mail merge document based on a particular county. Now I
wish to use the tables from another county in the database
without keeping the original county's tables there. Is
there a way to make my existing database and mail merge
document more generic so that I can easily switch from one
county to the other? (The tables for each county always
have the same number and names of fields with the same
primary key.)
I'm not sure if I wrote this correctly, but hopefully
someone will have some advice!
Thank You!
Randi