IF-THEN is a process in which the condition defines
like,IF the condition given from you is right one then it accept
and the THEN continue the other process.
In order to use the microsoft access query you need to have a variable (for instance, x) and something to compare it to (let's say, 20) So: If x > 20; Print "hello World! "
Also, Google your answers.
There is no if-then-else query in access. Instead a CASE statement has to used. For example:
select column1
'Status' = Case
when 'condition' then 'message1'
else 'message2'
end
from table1
The keyword is called IIF. The schema is like this: IIF([field1]="nok", "not ok", [field1]). If there is already a yes/no field you can write: IIF([field1], "new text", [field1]).
