Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save robwelan/959c58b0c00a37e57b549b5d4c96ae6b to your computer and use it in GitHub Desktop.
Save robwelan/959c58b0c00a37e57b549b5d4c96ae6b to your computer and use it in GitHub Desktop.
<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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment