Data Access page will not work from queries with wildcard

[Mike030882]

Hello,

I have a simple one table database, from which I then run queries with a single criteria (in this case, country name). I then have a data access page with the query as the record source.

This works fine with a simple one word query, however, i have a query for europe that is:

Like "*Europe*" Or Like "*European*" Or "EC"

The query shows 23 records. The data access page will only show the 19 records with "EC".

Further, I wanted to search a field, so i have a query:

Like "*rice*"

the query shows records, but the data access page is totally blank.

Is there any way to make the data access page show records from a query with a */wildcard?

Finally, is it possible to create a wildcard query such as the Like "*rice*" above, that will show if a record has the word rice in any one of several different fields?

Regards, Mike

 

[PHV]

If ADO then the wildcard is % instead of *.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Mike030882]

worked great, thanks!