importing data and concatenating tables

[Kieran the Fish]

Hi

Found a problem I can not fix (back only recently to coding in Access so I
am very rusty!)...

I am importing a database from a legacy HR system, and it comes in two
formats, one with employee details, anotehr with the same details and the
training record.

The problem is that any employee who has not undertaken any training has no
training record and as such does not appear on that import. They only appear
on the import for the employee details only. It is not possible to fix this
on the legacy database much as I would like to given it would be the ideal
solution.

I have tried using the unmatched query but it does not work - not sure why
but the remaining stock of hair is running out...

Any solutions I could try, maybe some sort of specialised union query or a
make table query involving both tables?

With sincere thanks in advance

 

[Jeff Boyce]

Without a bit more information, ...

You haven't posted the SQL of your unmatched query. If I had to compare two
tables of data, looking for the "missing" values in one of them, I, too
would use an unmatched query.

You haven't indicated how your unmatched query fails ... that is, what it IS
doing that you believe is not correct.