Latest activity

  • Papa_Bear1
    Interesting background! I think your initial answers are succinct, and only lengthier as the details unfold. Seems appropriate to me...
  • M
    Mark_ replied to the thread Favorite Quotes.
    I GROK IN FULLNESS.
  • M
    Mark_ replied to the thread New Avatar.
    Two of you over there making fun of me cuzz I'm startin to look like one of them there long haired hippies!
    • Consessions.jpg
  • C
    ClaraBarton reacted to cheekybuddha's post in the thread Solved Where string with Like Like.
    Are you sure this doesn't work? You should see only: transactions from account = 47 uncleared transactions from any time both cleared...
  • C
    ClaraBarton replied to the thread Solved Where string.
    I've worked all afternoon on this to find you nailed it all along: fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate...
  • cheekybuddha
    cheekybuddha replied to the thread Solved Where string.
    Try the following queries in the query builder to see if they produce different results: SELECT t.TransactionID, t.fAccountID...
  • RonPaii
    RonPaii replied to the thread Favorite Quotes.
    ACHTUNG! ALLES TURISTEN UND NONTEKNISCHEN LOOKENPEEPERS! DAS KOMPUTERMASCHINE IST NICHT FÜR DER GEFINGERPOKEN UND MITTENGRABEN...
  • C
    ClaraBarton replied to the thread Solved Where string.
    This form has been working on account and date but I was not getting the uncleared from before the date. Adding the cleared and...
  • C
    ClaraBarton replied to the thread Solved Where string.
    @cheekybuddha. That's exactly what I want. fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And...
  • cheekybuddha
    cheekybuddha replied to the thread Solved Where string.
    Are you sure this doesn't work? You should see only: transactions from account = 47 uncleared transactions from any time both cleared...
  • C
    ClaraBarton replied to the thread Solved Where string.
    Cleared = False OR ((tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) AND (fAccountID = 47)) Cleared = False AND...
  • C
    ClaraBarton replied to the thread Solved Where string.
    fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) Doesn't limit dates or account
  • Cotswold
    I thought about that but being sleep deprived I was thinking that the dcount might be slower than using a dictionary if making a 100...
  • C
    ClaraBarton replied to the thread Solved Where string.
    Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026# AND fAccountID = 47 Cleared = False Or...
  • M
    Mark_ replied to the thread Solved Where string.
    Something to keep in the back of your head. When you have multiple criteria you can also create a set of matching queries to UNION...
Back
Top Bottom