selection of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

michel - 15 May 2005 00:58 GMT

Hi, i'm trying to select certain records from my file. For example, how can I
select all records that end in '-5' or that contain a particular word

Thanks

Signature

michel

Reply to this Message

Ofer - 15 May 2005 01:25 GMT

Select * From MyTable Where MyField Like "*-5"
or
Select * From MyTable Where MyField Like "*AnyPartOfField*"

> Hi, i'm trying to select certain records from my file. For example, how can I
> select all records that end in '-5' or that contain a particular word
>
> Thanks

Reply to this Message

Jeff Boyce - 15 May 2005 01:26 GMT

Michel

A query can use a field that you add, based on a function like Right(). Add
a field in your query something like:
Right([YourField],2)
then set the criterion for that field as "-5".

If you want a query criterion to look for a field that contains the word
"word", use something like the following for the criterion:

Like * & word & *

And if you want to parameterize it, make it:

Like * & [Enter your search string/word] & *

Signature

Good luck

Jeff Boyce
<Access MVP>

> Hi, i'm trying to select certain records from my file. For example, how can I
> select all records that end in '-5' or that contain a particular word
>
> Thanks

Reply to this Message