Is it possible to use "all" in a paramater query

  • Thread starter Thread starter Jgarcia2k3
  • Start date Start date
J

Jgarcia2k3

Is there anyway to have a user type in “all” in a parameter query an
all of the fields show up in a query?

In my query I am tracking due dates for various credit applications fo
companies. This all depends on the jurisdiction. A company can hav
more than one jurisdiction; for example

xyz has applications due in NY, NJ, and PA

What I want in the parameter query is that on my jurisdiction field, i
they type in all they will not miss a jurisdiction.

Thanks,
Jua
 
Juan,

Put something like this in the criteria of the query...
[Which jurisdiction?] Or [Which jurisdiction?]="all"
 
Back
Top