Search results

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...

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...

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...