Search results

i wont be keying in the data manually. would be importing a tab delimiter text file. And i have a query to check for some stuff but now i need to add in the character check.

Or are there anyway to check by creating an additional table to check letter by letter for characters/letters that are allowed.

I want my to detect special characters in my descriptions that are not found on keyboard and display as error. Tried using the following Description check: IIf([Common Description] Is Null Or [Common Description] Not Like "*[!a-z0-9@=.^_$%!#&'`(){|}*?~[]/\-]*" And [Description Local] Is Null Or...