Simple Query Question

[Jthoms]

Hi

Simple Question

I have a table that i want to serch a field for a string of text. The data
can be in the following possible forms



0101234
or
0101234 / 3542176
or
2834734/ 0101234

or
2834734/ 0101234/3744565

using a parameter query i can get it if the value is along

but how to serch inside a field????


Thanks

 

[Roxie Aho]

Try: Like "*" & [Enter any character to search by: ] & "*"
Modify the text in brackets to fit your situation.

Help has a pretty good explanation. In the Index, find
Parameter

Roxie Aho
(e-mail address removed)

 

[Evi]

Use the Like filter

type

Like *102*

in the Criteria row of the query to display records that contain those
numbers together.

You can also do a fast filter by right clicking on the field and typing

Like *102*

in the Filter box.

For your parameter query, put

Like "*" & [What Numbers?] & "*"

in the Criteria row. Note that you need the quotation marks and the & signs

Evi