jeudi 2 juin 2016

how to use Microsoft access embedded macro if with a result of a query (access)

i have searched for a solution but couldn't find any.. I have a count query which returns a result. i want to use the IF in the embedded macro to determine if the result of the query is bigger than zero.

for example: [myquery]![countof ID]>0 something like that.

the thing is that i don't know how to do this simple comparison in the IF in the macro this is where i want to create the condition

sadly we only learnt how to use the macro builder so people answering with code wont help...here is the macro builder

thanks in advance for any help!

Aucun commentaire:

Enregistrer un commentaire