Data types of all the fields in the table are textual. For the parameter
queries the fields are created through combinations of more than one regular
fields present in the table. Your suggestion of the standard module didnt
show any result. Kindly help me much more.
With best regards
--
nandini
"Tom van Stiphout" wrote:
[Quoted Text] > On Tue, 30 Dec 2008 18:44:01 -0800, Nandini
> <Nandini[ at ]discussions.microsoft.com> wrote:
>
> One suggestion would be to perform the search not in the regular field
> but in a derived one:
> (I am assuming you are searching in the Summary field of SomeTable)
> select Summary, StripPunctuation(Summary) as SummaryStripped
> from SomeTable
>
> StripPunctuation is a Public Function you write in a standard module.
> Something like this:
> public function StripPunctuation(s as string) as string
> s=Replace(s, ".", "")
> s=Replace(s, ",", "")
> s=Replace(s, ";", "")
> StripPunctuation = s
> end function
>
> Then apply your criteria to the new field.
>
> -Tom.
> Microsoft Access MVP
>
>
> >I have created a bibliographic database using Access 2003. Here some
> >parameter queries have been made to retrieve textual information through the
> >text box. For this I have designed the criteria as Like "*" &
> >[Forms]![Form1]![TextBox1] & "*" for a particular field. This crieteria can
> >retrieve any exact single word or phrase. But it couldnt retrieve phrases
> >containing any punctuation, if exact punctuation is not supplied as input. I
> >want to make such criteria, so that the presence of punctuation in a phrase
> >can be ignored at the time of input.
> >Wth regards,
>
|