Appending 2 data sheets

S

soulstonedk

I have 1 data sheet that contains a large amount of data for different
containers.
its build up like this

Serial repair text cost total

APMU159MCI xxx xxx xxx
APMU159MCI xxx xxx xxx
APMU159MCI xxx xxx xxx
APMU159MCI xxx xxx xxx

MAEU155MXI xxx xxx xxx
MAEU155MXI xxx xxxx xxxx

im sure oyu get the point now! now i recently got a new report that contains
the amount of containers for each serial number. like 100 containers in
serial number apmu159mci.
the file is like this:

Serial Amount

APMU159MCI 100

Are there any way to make access combine the two reports. Like get it to
search for the serial in the first report based on the 2nd and if it finds a
natch then add a new column with the amount in it?

Thx in advance

Jonas Kristensen
Centre Line Management
A.P. Møller
Copenhagen - Denmark
 
Top