Search 2 tables

[Guest]

I am using Access 2000
I have two DBs with test records and 1 Db with Employee inform. They are
all tied together with an ID number for the employee. I want to create a
report that will list all of the tests from both Dbs. Db 1 - has a field
[test]. Db 2 has a field [test-eye].
In the Query, I brought up all 3 Dbs. I tried creating a formula that would
grab both [test] and [test-eye]. Ex: [test] and [test-eye]. But this did
not work. I think I need to tell the query where each field is located (in
which Db) but I can not remember the correct method for listing the DB and
the field together. Can anyone help me?

Aurora

 

[Guest]

Hi
Just check if this is what u asked.

Select db1.test,db2.test-eye from db1,db2
where db1.employee_id = db2.employee_id;

Thanks
Nish.