How Do I Search On A Keyword Within My Table??

wardy

Registered User.
Local time
Today, 16:24
Joined
Sep 4, 2007
Messages
21
Hello all, once again I would very much appreciate anyones help on what may be quite a simple issue,, my problem (or one of!!) is as follows:
I have a table that contains approx 3k records I wan to run a query that allows me to select a certain number of fields with a group. From this I mean, I have all records grouped by discipline, firstly its easy for me to determine the discipline I require (I do this in the design view by adding the discipline number in the criteria row.) next I want to find a certain number of the records that are within my chosen discipline,, the records I wan to see all contain the word ‘alignment’. I tried entering ‘alignment’ on the criteria row but that didn’t get me anything,, the field that contains the word alignment also has many other words listed…
Please help
Many thanks
Jon
 
Try a criteria of:

Like "*alignment*"
 
Create Text Box on your form to enter your search string [SS]
Create Command Button that On Click event
[SS]=[*SS*]
DoCmd.Requery

This will add wildcards to your search string and then requery your seach criteria
 
that is great,,Like "*alignment*" ,, worked a treat
thanks again
Jon :)
 

Users who are viewing this thread

Back
Top Bottom