eg, Name entered: Jo
Search include: Jo, John, Johothan, Joanna, etc
could you please help asap
This post has been edited by thorny: 17 May 2006 - 06:32 PM
Posted 17 May 2006 - 06:22 PM
This post has been edited by thorny: 17 May 2006 - 06:32 PM
Posted 17 May 2006 - 06:57 PM
Posted 17 May 2006 - 11:01 PM
Amadeus, on 17 May, 2006 - 05:49 PM, said:
Posted 22 May 2006 - 08:51 AM
Posted 22 May 2006 - 05:23 PM
SELECT tblOwnerNames.nOwnerID, tblOwnerNames.sFirstName, tblOwnerNames.sName, tblOwner.sAddressLine1, tblOwner.sAddressLine2, tblOwner.sAddressLine3, tblOwner.sPostCode, tblMail.nChangedAddress, tblMail.[sName(New Address)], tblMail.sNewAddress1, tblMail.sNewPostcode, tblMail.sNewAddress2, tblMail.[sExclude(MailOut)] FROM (tblMail INNER JOIN tblOwner ON tblMail.nOwnerID=tblOwner.nOwnerID) INNER JOIN tblOwnerNames ON (tblOwner.nOwnerID=tblOwnerNames.nOwnerID) AND (tblMail.nOwnerNameID=tblOwnerNames.nOwnerNameID) WHERE (((tblOwnerNames.sName) Like (Forms!RealProperty2!txtSurname & “*”)) Or ((Forms!RealProperty2!txtSurname) Is Null) And ((tblOwnerNames.sFirstName) Like (Forms!RealProperty2!txtFName & “*”)) Or ((Forms!RealProperty2!txtFName) Is Null) And ((tblOwner.sAddressLine1) Like (Forms!RealProperty2!txtAddress & “*”)) Or ((tblMail.sNewAddress1) Like (Forms!RealProperty2!txtAddress & “*”)) Or ((Forms!RealProperty2!txtAddress) Is Null) And ((tblOwner.sAddressLine2) Like (Forms!RealProperty2!txtOwTown & “*”)) Or ((tblMail.sNewAddress2) Like (Forms!RealProperty2!txtOwTown & “*”)) Or ((Forms!RealProperty2!txtOwTown) Is Null) And ((tblOwner.sPostCode) Like (Forms!RealProperty2!txtOwPost & “*”)) Or ((Forms!RealProperty2!txtOwPost) Is Null));