Access query to find more than one random occurrence of character in a word

baseball

Board Regular
Joined
Apr 1, 2002
Messages
153
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
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,215,523
Messages
6,125,319
Members
449,218
Latest member
Excel Master

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top