Comparing two tables in a query

[David`]

I have a table with First, Last, Date. I would like to to
make a query that would list when these feilds match in
another table. If anyone could help me with this.

Thank you
David Ehrenreich

 

[Duane Hookom]

Do you mean when the fields are all the same or when they all match values
in similar fields in another table? Also, First, Last, and Date are all poor
choices for field names since they are either SQL aggregates or functions.

I think you might be able to just create a query based on both tables and
join the three fields. When you display the datasheet, only those that match
the three fields will show.