Recent content by willksr

  1. W

    WHERE clause in SQL statement

    OK, I answered my own question. I have a custom ribbon in my app so I seldom see the standard ribbon. I have to start my app with the shift key depressed in order to see the standard ribbon.
  2. W

    WHERE clause in SQL statement

    Why do them in Word? Because the font is much easier to read and I'm not that familiar with query designer. (I'm in my late 70's and my vision isn't what it used to be even with glasses.) I'll have to spend more time with query designer. And, after changing the smart quotes to standard double...
  3. W

    WHERE clause in SQL statement

    OK I solved it! I realized that all deposits are put in the table as positive amounts and all withdrawals are put in the table as negative amounts. So my WHERE clause is WHERE tblSavingsDepWith.[Savings DepWith Amount] < 0 It works perfectly! BTW the comments above about smart quotes is...
  4. W

    WHERE clause in SQL statement

    CJ, How do I run the SQL as a query? I'm not sure what that means.
  5. W

    WHERE clause in SQL statement

    The correct character is not the double quote. I have tried single quotes, double quotes, and double-double quotes. They all produce the same error. Access keeps asking me for the parameter value of "With" I'm starting to get seriously frustrated here. Do no one know what I need to do?
  6. W

    WHERE clause in SQL statement

    Jon, Here is the entire SELECT command. Everything works except the WHERE clause and the field it is referring to is Short Text. Forgive me for the long field names. SELECT tblSavingsDepWith.[Savings DepWith Number], tblSavingsDepWith.[Savings DepWith Date], tblSavingsDepWith.[Savings...
  7. W

    WHERE clause in SQL statement

    Actually, I had the SELECT clause in the wrong place. I put it where it belongs and now I get a message asking me to enter the parameter value for "With"
  8. W

    WHERE clause in SQL statement

    I've got a form that gets data from a table containing both deposit and withdrawal data So, in the SQL statement associated with a form I need to get only Deposit or only Withdrawal info. I put in a WHERE clause like this: WHERE table.depwithfield = "Dep" I get a missing operator error. What...
  9. W

    OLD Access programmer

    I'm a retired person who worked as an operating systems programmer in the 70's. Yes, that makes me an old codger, but I still like to keep my hand in it. I'm currently working on a home finance budgeting program using VBA for Access. I wrote most of this program 20 years ago and I have probably...
See more
Top Bottom