[Axapta-Knowledge-Village] tricky query

[Askeryd Thomas]

If there are two fields in different tables, say income and noOfChildren, and you have to set up a Query and not write it in code, i.e. use a Query with ranges and values and not write a select. How would one solve this problem: Selecting persons with (income < 3000 && noOfChildren < 2) || (income >9000 && noOfChildren > 5) ?   Simply putting in income.value (< 3000 || > 9000) and noOfChildren.value (< 2 || > 5) will not do it since that will also include persons with income < 3000 and noOfChildren > 5 and vice versa. So how can this be solved? Please help me out with this. If you know the answer it will not take you much time to answer.       ______________________________________ Thomas Askeryd WM-data Affärssystem – Axapta             Sandhamnsgatan 65 Box 270 30, 102 51 Stockholm 08-6710474 0733-988686 [EMAIL PROTECTED] http://www.wmdata.se     The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.   Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS  Visit your group "Axapta-Knowledge-Village" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.