Text seach of memo fields

[mscertified]

I have a table containing 3 memo columns.
The user wants to be able to search for records in the table matching on
text in
the 3 memo columns.
There will be 25,000+ records.
This should run as quickly as possible.
Has anyone done this?
What is the best technique to use?

 

[Rick B]

You would build a query and put the criteria you'd like to search under each
memo field. If you want the user to enter the string to search when the
query is run, you could put something like he following:

Like "*" & [Enter string to find] & "*"


You would put this under each of the three memo fields, but you'd put is on
a separate row under each field. Placing criteria on multiple rows creates
an "OR" condition where a record will result if any of the three fields
matches. Placing it all on the same row would require that the text were
found in each of the three memo fields.

 

[MikeJohnB]

I have a table containing 3 memo columns.
The user wants to be able to search for records in the table matching on
text in
the 3 memo columns.
There will be 25,000+ records.
This should run as quickly as possible.
Has anyone done this?
What is the best technique to use?

Just for information, there are two methods of doing this at site

support.microsoft.com/kb/117217

I have done the same for a single memo feild as follows:

Generate a query based on the table which contains the memo feild. In the
criteria I typed as follows.

Like [Enter the text to be searched for]

Running the query will pop up a search question box asking the operator to
enter the text to be searched for. Entering one word enclosed in a wild card
*Example* will display all memo feilds containing that text.

I don't say that this is the right way to do this, just one way of getting
where you want but there must be a better way and perhaps there is a way of
including the wild card in the criteria syntax

 

[MikeJohnB]

Rick is spot on with the syntax and I cant spell Field either, Thanks Rick

You would build a query and put the criteria you'd like to search under each
memo field. If you want the user to enter the string to search when the
query is run, you could put something like he following:

Like "*" & [Enter string to find] & "*"


You would put this under each of the three memo fields, but you'd put is on
a separate row under each field. Placing criteria on multiple rows creates
an "OR" condition where a record will result if any of the three fields
matches. Placing it all on the same row would require that the text were
found in each of the three memo fields.

--
Rick B

I have a table containing 3 memo columns.
The user wants to be able to search for records in the table matching on
text in
the 3 memo columns.
There will be 25,000+ records.
This should run as quickly as possible.
Has anyone done this?
What is the best technique to use?