Locating duplicate records in various tables

[prismlight]

hello
I am trying to create a query in design view and locate duplicate data that
appears in various tables. Im trying to specify a criteria and I thought I
read somewhere that "=" would work but its not working...any ideas?

thanks