Parameter Query

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I have a check box in my query. When I type "Yes" into the criteria row and
run the query, I get the results I want. However, when I change it to a
parameter query, typing results in an error message of that it is too complex
to be evaluated. When I put -1 or 0 though, it works. How can I get the user
to input Yes or No and get vthe results wanted?

Thanks
 
Have you defined the data type of the parameter? If it's the default of text,
it will see "Yes" instead of Yes. There is a difference. You want the
paramter defined as a Yes/No data type.

What version of Access? How to define the parameter is very different from
2007 compared to all the older versions.
 
Hi Jerry

I'm using 2003. I've subsequently found that I can achieve it by an Iif
statement.

Many thanks
 

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

Similar Threads

Multiple Parameter Crosstab query filter by form 1
Parameter Query Won't Run 0
Parameter Query No Results - Needs to Auto Create Record 4
Query error, too few parameters 0
If Statement with "*" in Query 2
Parameter Queries in Crosstab Query 2
optional parameter for query 2
Parameter query not returning all results 4

Back
Top