Search results

  1. P

    delete where field is empty

    Trying to use a SQL statement (within a macro) to delete a row if a field is empty. This isn't working. DELETE FROM PM0900Aa WHERE (((PM0900Aa.[TEAM])="")); No errors, just doesn't do the job. Seems to be deleting data from just that field not deleting the whole row (found this when I tried...
  2. P

    Alert message suppression - how to?

    I have a macro that runs 29 SQL commands against a table in my Db. The function of the macro works fine, but when I run it I get a confirmation alert for every one of the 29 SQL commands that requires me to confirm each one manually. Is there a way to suppress these alerts so I don't have to...
  3. P

    conditional text content

    I can't find how to do this. (Note: I'm sure this syntax is all wrong, I don't know Access very much) In my report I need to do something like : IF (Before OH > 0) AND (([Before OH]+[OH Cost Calc])<0) DISPLAY "OH", ELSE DISPLAY " " and then this one: IF (Before OH < 0) AND (([Before OH]+[OH...
Back
Top Bottom