I am buffled by this script. I am new at this.
Thanks.
<CFIF Form.Name NEQ "">
<!--- Access version --->
<CFIF Server.OS.Name CONTAINS "Windows">
AND (strFName LIKE '%#Form.Name#%'
OR strLName LIKE '%#Form.Name#%'
OR strFName & ' ' & strLName LIKE '%#Form.Name#%')
<!--- dBase Version --->
<CFELSE>
AND (Upper(strFName) LIKE '%#UCase(Form.Name)#%'
OR Upper(strLName) LIKE '%#UCase(Form.Name)#%'
OR Upper(Trim(strFName)) + ' ' + Upper(Trim(strLName)) LIKE '%#UCase(Form.Name)#%')
</CFIF>
</CFIF>
<CFIF Form.strDptIDFK NEQ "All">
AND strDptIDFK = '#Form.strDptIDFK#'
</CFIF>
Thanks.
<CFIF Form.Name NEQ "">
<!--- Access version --->
<CFIF Server.OS.Name CONTAINS "Windows">
AND (strFName LIKE '%#Form.Name#%'
OR strLName LIKE '%#Form.Name#%'
OR strFName & ' ' & strLName LIKE '%#Form.Name#%')
<!--- dBase Version --->
<CFELSE>
AND (Upper(strFName) LIKE '%#UCase(Form.Name)#%'
OR Upper(strLName) LIKE '%#UCase(Form.Name)#%'
OR Upper(Trim(strFName)) + ' ' + Upper(Trim(strLName)) LIKE '%#UCase(Form.Name)#%')
</CFIF>
</CFIF>
<CFIF Form.strDptIDFK NEQ "All">
AND strDptIDFK = '#Form.strDptIDFK#'
</CFIF>