I have update query(sum) with tow criteria name1=name2 and the second criteria is writer1= writer2 so in case name1<>name2 or writer1<>writer2 then the action doesn't show any message or warning that there is wrong for to use the second query.
is it clear my question?
better but still not clear. to help you we need to understand what you are trying to do. So show examples of each of the queries and the outcome you require
I have update query(sum) with tow criteria name1=name2 and the second criteria is writer1= writer2 so in case name1<>name2 or writer1<>writer2 then the action doesn't show any message or warning that there is wrong for to use the second query.
is it clear my question?
better but still not clear. to help you we need to understand what you are trying to do. So show examples of each of the queries and the outcome you require
I wrote the code in vba and use update query(sum) but when one criteria isn't achieved , I want a message tells the user that there is wrong in criteria or not achieved then I will use the second query , all these I have done in vba.
Can you please write out what you are trying to do without resorting to code? Your intent is important, then we can help identify what the code should be for your intent.
Can you please write out what you are trying to do without resorting to code? Your intent is important, then we can help identify what the code should be for your intent.
as I have written previously , I have updatequery(sum)with tow criteria so I need a code that if one of its criteria is not right or empty to show message that "check the name or the writer" and so on and if we can show message then move to second query.
