Access Query - Add column to count matching values in another query -

i add column query counts number of matching [ip_address] values query called [qry_ip_blacklist]

select tbl_ip_addresses.ip_address, tbl_ip_addresses.selected tbl_ip_addresses (tbl_ip_addresses.selected=true); 

i have tried following new column:

expr1:

(select count(*) qry_ip_blacklist ip_address = ip_address) 

but seems show total number of records in [qry_ip_blacklist]

how can achieve please?

if understand correctly, need add group clause blacklist query:

select   tbl_ip_addresses.ip_address ,tbl_ip_addresses.selected ,blacklist.count  tbl_ip_addresses   left join (select count(qry_ip_blacklist.ip_address) count, qry_ip_blacklist.ip_address qry_ip_blacklist group qry_ip_blacklist.ip_address) blacklist  on tbl_ip_addresses.ip_address = blacklist.ip_address  tbl_ip_addresses.selected = true;