February 11, 200421 yr Newbies What is the best way to match the contents of a field (text) with all items in a value list so that it returns a "yes no" or" 0 1"? Example: "song title" field matching to "original song title" field to compare for spelling mismatch, and flagging this mismatch. Thanks.
February 12, 200421 yr Look at the Exact(field1, field2) function. It's case sensitive. To effectively make it case insensitive use the Lower() function... Exact( Lower(field1), Lower(field2))
Create an account or sign in to comment