OR rather than AND

[potts]

I'm building a multi criteria search form. All is well, but I now want to make one of the controls, one containing multiple selections, an OR rather than an AND variable.

Does anyone know how to do this?

Thanks

 

[llkhoutx]

One way is to place "Or'ed" criteria on separate rows of the QBE frame.

 

[potts]

I'm not sure I understand!

 

[llkhoutx]

Create a table, tbCompanies, with one field, sCompany (Text 3), and then cut & paste the following in the SQL view of a query:

SELECT tbCompanies.sCompany
FROM tbCompanies
WHERE (((tbCompanies.sCompany)="ABC")) OR (((tbCompanies.sCompany)="XYZ"));

then display the query in the Design view. You'll see that the "ABC" and "XYZ" criteria are on separate rows of the QBE frame.