Steven.Foy
Steve
- Local time
- Today, 06:29
- Joined
- Jul 15, 2004
- Messages
- 23
Hi wonder if anyone can help.....
Am trying to filter a query based on whether a check box is selected or not. I've included the criteria row from my Query....
IIf([Forms]![frmfunctionlocation]![rbexcludeBIF]=-1,Not Like "BIF",Not "")
I read this as... if the check box(rbexcludeBIF) has been clicked(=-1) i want to not include the string BIF in my query. Else i want to include all fields(i.e not blank)
I think this is nearly right...but at the moment the query returns a blank screen!
Any ideas?
Am trying to filter a query based on whether a check box is selected or not. I've included the criteria row from my Query....
IIf([Forms]![frmfunctionlocation]![rbexcludeBIF]=-1,Not Like "BIF",Not "")
I read this as... if the check box(rbexcludeBIF) has been clicked(=-1) i want to not include the string BIF in my query. Else i want to include all fields(i.e not blank)
I think this is nearly right...but at the moment the query returns a blank screen!
Any ideas?
Last edited: