access 2002

[Guest]

I have prepared a database for service management. I have distributed this to
all different regions. At the end of every month the database is sent to me
filled up with the necessary data. I have a problem how to combine this data
into one place so that I can have a overview of the complete data.

Can anyone help me on this?

Thanks and Best Regards
nvk

 

[TC]

Each table should have a field for RegionNumber. Each Region would put
their own unique number into that field. Then, you could copy /all/ the
regions' information, into a single set of tables. The different
RegionNumber values would let you pull-out the data for any particular
region, ignoring all the other regions.

HTH,
TC [MVP Access]

 

[Guest]

Check out Replication in Help.

 

[John Vinson]

I have prepared a database for service management. I have distributed this to
all different regions. At the end of every month the database is sent to me
filled up with the necessary data. I have a problem how to combine this data
into one place so that I can have a overview of the complete data.

Can anyone help me on this?

Well, not without knowing a lot more about the structure of the
database!

You can use File... Get External Data... Link to link to other
databases' tables; you can use Append queries to append the data in
them to tables in your local database. Depending on how the tables are
structured this can be very easy or it can be quite difficult (do the
different tables have conflicting Primary Key values for example)?


John W. Vinson[MVP]