Option Groups

[William Phillips]

I am using a form to provide criteria for a report. I want
to use an option group to select transactions with
different statuses. I have Quotes, Orders Cancelled and I
also want to select all. I can get the individual status,
but I cannot get "All" to work. Can this be done? I ahve
to use logic in the QBE as follows: Select From Table =
tblQuoteDet and the field is called Status. I have the
following logic in the criteria line of the QBE: IIf
([Forms]![frmRept]![Status]=4, >0, [Forms]![frmRept]!
[Status]) As I said this works fine for the individual
circumstances. When I run the report the QBE changes to
the following: IIf([Forms]![frmRept]![Status] = 4,
([tblQuoteDet].[Status])>0,[Forms]![frmRept]![Status])

Thanks