Filter by multiple criteria

[JVM15]

!IsNull([Assignment])
AND
[GLAccount]=("0044574098")
AND
[GLAccount]=("0044574099")

I keep getting zero true results when I add the second GL criteria, However if I do just one or the other it runs fine. Does anyone have a better way? I want only those two accounts to populate

[echuong1 · Accepted solution]

The criteria is looking for a record to have both of those account numbers. Try this:

!IsNull([Assignment])
AND
([GLAccount]=("0044574098")
OR
[GLAccount]=("0044574099"))

[BrandonB]

It is impossible for the same cell to be two separate GL Accounts simultaneously. I would recommend changing it to the following: 

!IsNull([Assignment])
AND
([GLAccount]=("0044574098")
OR
[GLAccount]=("0044574099"))

[BrandonB]

@echuong1 you are lightning fast to those responses!🙂

[JVM15]

Thanks for the assist!

[MarqueeCrew]

@JVM15 ,

I prefer IN statements:

!IsNull([Assignment])
AND
[GLAccount] IN ("0044574098", "0044574099")

cheers,

mark