A
Aikman2x
I need some help on filtering my form. I need to do some data entry
in form view (more convenient for me compared to datasheet view) for
any record that contains a specific word in a single field. For
example, let's use the word 'hammer'. The problem I'm having is this.
Some of the records can contain any of the following:
hammer
hammers
ball ping hammer
ball ping hammers
hammer (followed by some more text)
hammers (followed by some more text)
Is there a simple method to filter every record that contains the word
hammer, regardless if it's singular, plural, has miscellaneous text
preceeding it, or has miscellaneous text following it? Any help is
greatly appreciated. Thank you in advance.
Michael
in form view (more convenient for me compared to datasheet view) for
any record that contains a specific word in a single field. For
example, let's use the word 'hammer'. The problem I'm having is this.
Some of the records can contain any of the following:
hammer
hammers
ball ping hammer
ball ping hammers
hammer (followed by some more text)
hammers (followed by some more text)
Is there a simple method to filter every record that contains the word
hammer, regardless if it's singular, plural, has miscellaneous text
preceeding it, or has miscellaneous text following it? Any help is
greatly appreciated. Thank you in advance.
Michael