Criteria of parameter queries

  • Thread starter Thread starter Nandini
  • Start date Start date
N

Nandini

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,
 
On Tue, 30 Dec 2008 18:44:01 -0800, Nandini

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
 
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 said:
On Tue, 30 Dec 2008 18:44:01 -0800, Nandini

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,
Click to expand...
Click to expand...
 
Back
Top