Steve,
Thanks for your quick response. However, your suggested WHERE only
returns
the value of the "E" group, regardless if the RadioButton is checked or
not.
I need something like this:
IIf([Forms]![MyForm]![MyRadioButton] = 1,"E",([qryITEMS].[EDLP]) Is Null
Or
([qryITEMS].[EDLP]) = "E")
In my Select Query, without the form (returns ALL records)
WHERE (([qryITEMS].[EDLP]) Is Null Or ([qryITEMS].[EDLP]) ="E"))
Without the form (returns only EDLP "E" records)
WHERE ([qryITEMS].[EDLP]) ="E")
The field is Null or a value of E to flag the EDLP items. "*" as mentioned
before does not work.
I'm trying to provide the end-user with an option to get a Excel report of
ALL items or check the RadioButton for only the EDLP "E" items.
Currently, I have to provide the user with all items. After Excel export,
if they want only EDLP items, they have to delete all the ones that aren't
flagged with the "E".
--
Thanks, Kevin
Steve Schapel said:
Kevin,
WHERE [Forms]![YourForm]![YourRadioButton]=0 OR [qryITEMS].[EDLP]="E"
--
Steve Schapel, Microsoft Access MVP
AFSSkier wrote:
I have a select query that uses the following WHERE parameter. I want
to set
up an unbound FORM with a radio or toggle button that the user can
check to
replace a parameter prompt. The FORM needs to pass a "E" for the EDLP
group
only and a default "*" for all items.
WHERE ([qryITEMS].[EDLP]) = [Enter E for EDLP items only and * for All
items])