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

Thanks Autoeng, I understand the command you gave. Can you explain how to convert to code? And then where do you run it from, is it still a macro? Thanks, Jeff

I found the answer. For the record: >Tools >Options >Edit/Find >Confirm -Deselect "Action queries" -Click "OK"

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 went with the nested IIF and this code is working for me. Thanks for the discussion as it helped move me forward to the solution. =IIf([Before OH]>0 And [PROFIT]<0,"OH",IIf([Before OH]<0 And [PROFIT]<0,"COST","")) Jeff

Stew, That worked (after I changed IFF to IIF). I now need to combine the two examples I gave, so it will be like: if test A = true, display "OH", elseif test B = true, display "COST", else display " " I will work on it, but if you know how right away, I will appreciate a pointer also...

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