Filter Form Help

  • Thread starter Thread starter Aikman2x
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Polish my code, please 2
Migrate Excel into Access Database for query purposes HELP! 3
Check box on subform not working 1
Can I insert/paste email into an Access form field 4
VB Code for a Memo Field wanted 5
2007 Forms - Quick Filters not working 5
Sum Strictly by Date 5
One main form to update several tables? 3

Back
Top