Access 2000 query criteria

G

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?
 
D

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.
 
E

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???
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top