Can this be done in Access?

[quest4]

Can I run a second query from within the current running query? I would like to run it this way:
WHERE (A Is Null or A="xx&quot And If Exits (A="yy" Or A="zz&quot
Then qry1. I'm not sure of the syntax, but is this doable? Thanks.

 

[GUJUm0deL]

Hi, i'm not entirely sure on what you're askin to do, but i'm kind asure this might help you:

{SELECT A, B, C
FROM table1
WHERE A Is Null
OR A = "xx"
{SELECT A
FROM table1
WHERE A = "yy"
OR A = "zz"
}
}

Hope this helps... I have not failed; I merely found 100,000 different ways of not succeding...

 

[quest4]

What I am try to ask is:
if one of the following two conditions exists then run qry1.
Can this be done and how? Thanks for the response.

 

[quest4]

I managed to figure out that this can't be done. You must paste that query at the end of each line. It is big and hard to read, but it works fine, now. Thanks anyway.