Filter with an "OR" clause not working

M

Marvin

I have a form that is fetching records for a table named

  • I have 2 fields in the List table named:
    CallerId is the Id of a application user
    TempLock is a state field to prevent other users from accessing this record
    while opened by another user. It is derived by subtracting CallerId form
    10,000

    I used the "Advanced Filter" to build the following clause :
    (((List.CallerId)=0) OR ((List.TempLock)=9999))

    The filter is excluding records where CallerId<> 0 But is NOT including
    record were TempLock = 9999
    The First 5 records have different values in these 2 fields
    Table
    Record CallerId TempLock
    1 2 0
    2 0 Null
    3 3 Null
    4 0 9999
    5 5 9991

    When the form opens
    Its First Record is table record 2 Exactly what I need
    Its Second Record is table record 6 It should be table record 4

    What can be done??

    Thanks
    Marvin
 
Top