Hi All.
I am having a problem with a design of my Macro.
I am trying to use "If" statement which should say the following: if the data in the table is "No" (this table include two columns named "Processed" and "date". There is only one row in that table that says "No") then run query q_xxx_xxx and come up with a message box after, otherwise (else) come up with the message box. I will paste the screen shot of that below:
Unfortunately what I've done below does not work. I get the error fault, that I also pasted below. Please help?
Thank you!
Martin