Access 2007 on Windows 7
Have a field that has words of varying lengths that are made up of letters, numbers and characters. One stipulation is that a plus sign is always followed by an integer, +1 or +2 or +3. Using the Query Wizard, I used this to pull the records that have plus signs somewhere in the word. However, if I use Like "*" & "+" & "*" the total is slightly different than if I use Like "*" & "+1" & "*", etc.
The most obvious explanation is that some of the words contains more than one plus sign. How do I write the query to find those words?
Example of typical record: *BBC+1B>S.FB
Have a field that has words of varying lengths that are made up of letters, numbers and characters. One stipulation is that a plus sign is always followed by an integer, +1 or +2 or +3. Using the Query Wizard, I used this to pull the records that have plus signs somewhere in the word. However, if I use Like "*" & "+" & "*" the total is slightly different than if I use Like "*" & "+1" & "*", etc.
The most obvious explanation is that some of the words contains more than one plus sign. How do I write the query to find those words?
Example of typical record: *BBC+1B>S.FB