Access 2000 query criteria

[Guest]

I have a field on my form called "description" that can list a number of
insects. I want to create a query (and ultimately a report) that will ask
"Enter the Insect" and every record with that particular insect as part of
its description will come up (similar idea as searching for something on
ebay). I know how to do this if I enter a criteria for a specific insect (ex:
spider), but I do not want to have to create thousands of queries for all
the different insects. Is there a way to create one query to do this?

 

[Douglas J. Steele]

Create the query, and in the Criteria row under the Description field, put

Like "*" & [Enter the Insect] & "*"

When you run the query, you'll be prompted to enter the insect name.

 

[MH]

Not really on topic but spiders are not insects, they are arachnids.

Regards

MH

 

[evenezie]

Create the query, and in the Criteria row under the Description field, put

Like "*" & [Enter the Insect] & "*"

When you run the query, you'll be prompted to enter the insect name.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

I have a field on my form called "description" that can list a number of
insects. I want to create a query (and ultimately a report) that will ask
"Enter the Insect" and every record with that particular insect as part of
its description will come up (similar idea as searching for something on
ebay). I know how to do this if I enter a criteria for a specific insect
(ex:
spider), but I do not want to have to create thousands of queries for all
the different insects. Is there a way to create one query to do this?- Hide quoted text -

- Show quoted text -

I am trying to use specific criteria in my query to search for all
"tickets" for a particular "client." When I enter the Client's name in
the Criteria, my search result turn up empty. However, if I enter "Is
Null" it filters accordingly, only showing me those tickets without a
Client specified. I first created this query in a backup copy of my
database and it worked fine. When I recreated it in the "good"
version, this field doesn't seem to be working. Any ideas???

 

[Douglas J. Steele]

How are you running the query? If ADO is involved, try using %, rather than
*, for the wildcard character.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am trying to use specific criteria in my query to search for all
"tickets" for a particular "client." When I enter the Client's name in
the Criteria, my search result turn up empty. However, if I enter "Is
Null" it filters accordingly, only showing me those tickets without a
Client specified. I first created this query in a backup copy of my
database and it worked fine. When I recreated it in the "good"
version, this field doesn't seem to be working. Any ideas???

Create the query, and in the Criteria row under the Description field,
put

Like "*" & [Enter the Insect] & "*"

When you run the query, you'll be prompted to enter the insect name.