operator error?

[Schmidtty]

I have a filter table and a main data table

The filter is a bunch of yes/no fields based on product.
My data field tells me the number of accounts the person has.
I want to say if I check the product show me all the account that have at least one account.
My criteria in hte data field is:

IIf([relationship filter]![ckg_num]=True,1,Null)

The result of this is showing all the records that are 1. Similarly I can put a 2 or 3 in and recieve all records with that number of accounts. My problem..............

If I try:
IIf([relationship filter]![ckg_num]=True,>1,Null)
...wanting to get all records with one or more. I get all the records with 0. ?!?!?!?!
Is there some thing with the operator ">"? or what?

any thoughts would be great.

 

[Newman]

Not sure, but try "<1" instead of <1.