If Check Box is selected querie field

[GillinghamFC]

I have an access query that only needs to check if a deal is greater than >0 if the check box has been check example...

IIf([Forms]![frmClientReport]![CheckLive]=True,[TransactionID],>0)

For some reason this doesn't work properly when I put just >0 in the criteria box.

 

[smedvid]

IIf([Forms]![frmClientReport]![CheckLive]=True,[TransactionID],>0)

Sounds like you need another conditional IIF() in place of the >0.

IIf([Forms]![frmClientReport]![CheckLive]=True,
[TransactionID],
IIF([fieldvariable]>0,"true value","false value&quot)

Or

If [Forms]![frmClientReport]![CheckLive]=True Then
x=[TransactionID]
Else
If fieldvariable > 0 Then
???
Else
???
Endif
Endif

A little tough with having more information on the requirements you are attempting to meet.
htwh, Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...