"show only when value [Qry] when it is greater than 1 after combining the table"

you need not use a aggregate function to achieve this.

HAVING [Qry] > 1 will work.