SV: [Axapta-Knowledge-Village] tricky query

[Askeryd Thomas]

That page was good. Gonna have to bookmark it. I put it all in one value but then it doesn’t quite work:   qbrFamily.value(strFmt('(((noOfChildren < 2) && (Persons.Income < 3000)) || ((noOfChildren > 5) && (Persons.Income > 9000)))'));   It gives the right amount of posts but some are correct and others are only partially correct and should not have been included. Also that makes correct ones not being included. But maybe  I ll just have to work  a bit on it but if u see the problem just post the solution. Thomas.   Från: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Villa[EMAIL PROTECTED]] För Sonny Wibawa Adi Skickat: den 15 november 2005 02:11 Till: Axapta-Knowledge-Village@yahoogroups.com Ämne: Re: [Axapta-Knowledge-Village] tricky query   Hi, Askeryd Thomas, When writing the range criteria of the query, put the value using _expression_ in query range. For more detailed explanation about how to use _expression_ in query range, you may point to this article: http://www.axaptapedia.com/index.php/Expressions_in_query_ranges So, one of the solution of your problem, write these two ranges in the range criterias: ((income < 3000) && (noOfChildren < 2)) ((income > 9000) && (noOfChildren > 5)) Askeryd Thomas <[EMAIL PROTECTED]> wrote: 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.     Best regards, Sonny Wibawa Adi MBS Certified Professional - Axapta 3.0 Technical MCSD.NET MCAD.NET Yahoo! FareChase - Search multiple travel sites in one click. 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.