Hi guys (I have lost my password tomy orginal loggin - so have set up new one ...
what I am trying to do is
table 1 (account ) if ticked -1
now I have a report that filters only those that are ticked (fine)
what i want is to tick on my form to override and give me all (both-1 and 0)
IIf([forms]![SummaryReportsfrm]![trigger]=True,-1,0)
I thought
IIf([forms]![SummaryReportsfrm]![trigger]=True,-1, -1 or 0) would work but it does not ..
plot lost - how do I filter /not filter ?
help would be greatly appricated
G