Solved Where string (2 Viewers)

[ClaraBarton]

I've worked all afternoon on this to find you nailed it all along:

fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#)

I had some old (really old) uncleared transactions. Thank you so much for all your help.

 

[Gasman]

I've worked all afternoon on this to find you nailed it all along:

fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#)

I had some old (really old) uncleared transactions. Thank you so much for all your help.

That was posted in #13? and you said it did not work?

Doesn't limit dates or account

 

[ClaraBarton]