article-table02-building-and-using-a-table-of-queries

<table style="width:100%" border="0">
   <tbody>
      <tr>
         <td style="width:20%">Name</td>
         <td>Count_ExistingApplicantCountryInCountries</td>
      </tr>
      <tr>
         <td>String</td>
         <td>SELECT Count(*) AS countCountries<br/>FROM tblCountries, tblTEMP_NewMemberEntry<br/>WHERE<br/>(((LCase(\[tblCountries.[CountryName]))=LCase(\[tblTEMP_NewMemberEntry]!\[applicantCountry])));</td>
      </tr>
      <tr>
         <td>Purpose</td>
         <td>Check if a Country in the NewMember table applicant field exists in tblCountries.</td>
      </tr>
   </tbody>
</table>