Parameter Query Wild Card

I

Iram

I have a report that is running a parameter query against a form that that
has a list box. The list box gets its data from a table that has three
records.
Office1
Office2
Office3

I can run the report based upon which office I select in the field list
however how do I add a fourth record to indicate a wildcard that will allow
me to select it so that when I run the report all three offices will populate
the report?

Iram/mcp
 
K

KARL DEWEY

Edit your query criteria from this --
[Forms]![YourForm]![ListBox]
to this --
[Forms]![YourForm]![ListBox] OR [Forms]![YourForm]![ListBox] Is Null

An alternative is the add "ALL" to the listbox and edit query criteria like
this --
Like IIF([Forms]![YourForm]![ListBox] = "ALL", "*",
[Forms]![YourForm]![ListBox])
 

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

PivotTable based on multiple ranges or tables 2
List box instead of a text box in a parameter query 1
Complex Criteria Parameter Query 2
Parameter Query - Report 4
Multiple word search Parameter Query 4
Parameter Query 1
Repeating Query Parameter in Report 2
Sort query returns no records 1

Top