Re: [AccessDevelopers] really really really easy query question

[Jim Wagner]

Not what I was looking for. I have a column with the percentages and I wanted to query for just the 10%. I remembered my math class  and knew it was 0.1.  Thanks anyway.     Jim WagnerLonnie Johnson <[EMAIL PROTECTED]> wrote:    Not sure if this is what you want but if you are asking how to create a calculated column that is 10% of another column, then it would be...     SELECT MyField, MyField * .1 As MyCalculatedField FROM MyTable.     MyField is the actual field  MyCalculatedField will be the new column which will be MyField times .1     Hope this helps.luvmymelody <[EMAIL PROTECTED]> wrote:  how do I query for a value of 10% in a column of 10% or 20% etc. Jim Wagner            May God bless you beyond your imagination!Lonnie JohnsonProDev, Professional Development of MS Access DatabasesVisit me at ==> http://www.prodev.us         Yahoo! ShoppingFind Great Deals on Holiday Gifts at Yahoo! Shopping   SPONSORED LINKS         Microsoft access developer   Microsoft access help   Microsoft access database     Microsoft access training   Microsoft access training course   Microsoft access programming   
		Yahoo! Shopping 
Find Great Deals on Holiday Gifts at Yahoo! Shopping 






Please zip all files prior to uploading to Files section.





    


  
  
    SPONSORED LINKS
  
          
                  
            
        Microsoft access developer
      
                      
        Microsoft access help
      
                      
        Microsoft access database
      
              
                        
            
        Microsoft access training
      
                      
        Microsoft access training course
      
                      
        Microsoft access programming
      
              
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" 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.