Query returns value only if criteria is country code but not country name

[kchm2000]

Hi, i am trying to run a query using country as a criteria. In the "country all active query" even though the data is being drawn from the Issues table which holds the value by country name, the only way i can retrieve results is by query using the country code. Could someone show me how i can retrieve the results by country name, when i tried that in the query "copy of country all active" it doesn't work.

I have attached my database here Country Form v1.zip.

[ranman256]

Join the data table to the tCountry table on CountryCode field,
bring down the * from data table,and tCountry.CountryName
enter the country name in the criteria.

[davegri]

As ranman suggests, here's a graphic how.
Attachment 28160

[kchm2000]

thanks i understand and it works