Return all data from with parameter query

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

Hello,

I have a query, that is based off of a form. The form
has a combo box. In the query field (the one that is
based off of the combo box) I have an IIF statement to
return certain records depending on what is entered.
However, I can not get the query to return all of the
records when I want it to. What can I put in the IIF
statement to return every single record if selected to do
so from the combo box. I have tried "*",
like "*", "<>a", ">a", etc. Please help, Thank you.

-Sean
 
Dear Sean:

The way that a query determines which records are returned in your
context is fundamentally WHERE not IIf. IIf is generally used to
manipulate which values are returned, not which records are returned.

If you're working in the design grid, this is shown in the Criteria
area.

If you'll send the SQL you've created so far and an explanation of
which records you want it to omit you could probably get some more
specific assistance.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top