Multiple "Yes" criteria? 1

[lpgagirl]

I have two check boxes on a main form. One for DIC and one for NIC. I would like to run a query that shows all the record info. if either of these, DIC or NIC is clicked. I can create a query for each but I cannot create a query if the criteria is "Yes" for both. How can I do that?

Thanks in advance.

Jeannie

http://thefloyds.50megs.com/index.html

 

[SteveR77]

You need to set up the criteria for the fields to both be Yes. In the grid for the query just be sure to make sure the second yes is a line below the first one. This will set up a DIC OR NIC condition.


HTH,

Steve

 

[lpgagirl]

Boy do I feel like a dummy!

Thanks for your help.

Jeannie

http://thefloyds.50megs.com/index.html