Access, 2 tables with same values, help with report

[poc301]

I have a slight problem here with a database program I am designing. I have two excel spreadsheets, one created by one department here, and the other created by a second department.

I have the access program importing the relevant fields from both programs into 2 tables. Table 1 is the listing of employees in the company and their info (minus the location where they work). Table 2 is the listing of employees who are in this facility.

I need to prepare a report of all employees in this facility who appear on the other table.

I have a field in each table (both called F1) with the employee names.

Is there a way I can run a report in Access where it pulls all the info I need into a Report as long as the name appears in both tables F1 fields?

Even if I can create another table based on that info, and then just do a full dump to a report from that new table, that would be great.

I am not familiar with VB or SQL really, but I figure something like this would be doable, I just don't know how to go about writing it :

If Table1.F1 == Table2.F1 Then {
Append Table1.* INTO NewTable3
}

Something where if the name on F1 in Table1 matches the name on F1 in Table2, it takes all the data from that record and appends it or dumps it brand new into a NewTable3..



Any help is appreciated.

Thanks,

Bill

[FishVal]

Hi, Bill.

You are looking for table joining.

The following query will return dataset consisting of Table1 and Table2 records where Table.F1=Table.F2.

SELECT Table1.*, Table2.* FROM Table1 INNER JOIN Table2 ON Table.F1=Table.F2;