Hi All,

I am using Access XP,

I have Macro call Save, Where it contains 11 actions of openQuery( to run append queries). Out of this eleven queries 4 queris should run only when the condition met for each queries.

for example if those queries are a, b, c and d.

if a=0 then except query "a" other all 10 queries to be run and so on,

so in this way there will be 15 permutation will occur.

[a=0 b,c and d not Zero
b=0 c, d and a not zero
c=0 d, a not zero
d=0 a, b, c not zero
a=0 and b=0 c and d not zero

Please any one can help how can i define a code to run this macro, for each condition