sql/union query Help

[striker]

This should be nice and easy for any access guru out there.

In a union query can I have multiple criteria.

for instance from the where clause.

where field a = "some text" and where field b = "some other text" and where field c ="some more text" etc.

If it can be done can someone please post an exact example as i've tried and can't get it to work, and i'm not sure if i'm getting the code wrong or if it just can't be done.

thanks for all your help,

 

[striker]

Thanks Pat for the help i'd tried "and where" many times and it didn't work. No wonder

Thanks again.