Re: [Axapta-Knowledge-Village] tricky query

[Sonny Wibawa Adi]

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 AdiMBS Certified Professional - Axapta 3.0 TechnicalMCSD.NETMCAD.NET
		 Yahoo! FareChase - Search multiple travel sites in one click.

 

 





Sharing the knowledge on Axapta.





    


  
  
    SPONSORED LINKS
  
          
                  
            
        Business finance course
      
                      
        Business to business finance
      
                      
        Small business finance
      
              
                        
            
        Business finance consultant
      
                      
        Business finance magazine
      
                      
        Business finance schools
      
              
                    
           
  







  
  
  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.