If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Parameter Query Wild Card
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 |
#2
|
|||
|
|||
Parameter Query Wild Card
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]) -- KARL DEWEY Build a little - Test a little "Iram" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|