Access Query

  • Thread starter Thread starter Jodi
  • Start date Start date
J

Jodi

I am trying to query 2 tables. The first table (1) has
old data in it from previous years. The second table is
an updated table that contains records of old entries
that were updated plus last years records. I want to
combine these two tables into one, so that when I open it
up the new query/table has all the old data (which would
now be updated) and all the new (last years) data. I
can't however have any duplicates in the case numbers (a
row which everything is sorted by). Please let me know
as to exactly how to do this. I've been trying all day
and cannot figure it out.
 
You need to tell us more about the structure of the two tables -- primary
keys, fields, value types, etc.

Are you wanting to combine the data into a single table? or to use a query
that will combine the data on the fly?
 
I have one database that has a whole bunch of accident
stats in it. case number, no. occupants, no injured, km,
etc, anything to do with an accident - it is all
numbers, the second one is exactly the same. i guess the
primary key (i think i have one is the case number -
can't have any duplicates.)

I want to be able to combine these two tables somehow so
that the new information is included and any old
information that is updated will be updated in the new
one. it doesn't really matter how they are combined just
as long as i end up with a database that has all the new
and updated information in it.

Thanks
Jodi
 
So both databases have similar data in similarly designed tables? Do any of
the data in one database duplicate data in the other? Or do you just want to
combine the data into a single database by adding the data together?

You can copy data from a table in one database into another table in another
database if you link the first table (File | Get External Data ... | Link)
in the second database and then write an append query to copy the data into
a table in the second database. You then can copy those data into the
"final" table in the second database (this "final" table may contain the
other set of data, or you can then use another append query to copy the data
from the second database into this "final" table).
 
Back
Top