I have a database with 3 tables. All 3 tables contain the same fields.

One of the fields is named "Email Address" and another one of the fields is named "Source" (which in each table is the name of the table itself).

My goal is to consolidate the 3 tables into 1 table based on a unique identifier (in this case Email Address) and identify the Sources where the same email address appears in each of the 3 tables.

I tried using an Append query, but this did not seem to work. Can someone please help?