SQL statements

E

EFowler

Is it possible to create a SQL statement in the Filter portion of a custom view or use any coding option that allows for the following

Contact 1 belongs to categories; Suppliers, Preferred and Non-Preferred
Contact 2 belongs to categories; Suppliers and Non-Preferre

My customer wants to see only the contact(s) that belong to all three categories...so by changing the SQL statement to ("urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" = 'Non-Preferred' AND "urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" = 'Preferred' AND "urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" = 'Suppliers'), we can accommodate, however they also want to the ability to view any contacts belonging to one or more (using the OR statement). Is there anything I can write to accomodate an AND/OR situation

Thanks
Erin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify Custom View SQL Filter Tab 1
Custom Filtered View 1
Outlook 2007 SQL syntax to filter views of tasks and todo items 1
Programmatic construction (macro) to make complex views on the fly 4
Outlook 2003 Contact Filters 1
Outlook Displaying HTML Code 0
Page numbering with Merged Document and IF statements 1
Customise current view 0

Top