From: harrisjr@bwsc.org   
      
   As I have said many times I LUV this NewsGroup.   
   THANK YOU TO ALL who replied to this POST   
      
      
   Liz,   
      
   BTW 10/1/06 - 1/1/06 should have been 1/10/06 - 1/1/06, sorry   
      
   I did mis-understand what you meant by INCLUSIVE.   
   BUT I AM STILL HURTING :-(   
      
   Year   StreetCODE      STR$      Begin       End           #   
   a) 2005   06520    $282,208.40   09/15/2005  12/31/2005	  90 	 	 	   
   a) 2006   06520    $282,208.40   01/01/2006  04/01/2006  107   
      
   b) 2006   29980     $71,442.00   01/15/2005  02/01/2005   17   
      
   c) 2005   14030     $69,133.25   01/01/2005  01/10/2005  9 +1=10 	 	 	   
   c) 2006   14030     $69,133.25   01/01/2006  04/01/2006  46+1= 47   
      
   If 1 is added to a) Total # of days(TNOD) as one entry   
   [ 4/1/06 - 9/15/05 ] TNOD is 198 and calcs back to STR$   
   YET   
   If 1 is added to a) # of days as 2 entries   
   TNOD is 199 and DOES NOT calc back to STR$   
   BUT   
   If 1 is added to b) TNOD is 18   
   [ 2/1/05 - 1/15/05 ] DOES NOT calc back to STR$   
   HOWEVER   
   If  TNOD is 17 for b)   
   [ 2/1/05 - 1/15/05 ] DOES calc back to STR$   
      
   from all of the above it seems   
   If the date range is in 2 years or more add 1 day to each range   
   UNLESS   
   d) The date range in 2 years or more is in consecutive months then add 1   
   day to TNOD   
   OTHERWISE   
   Use (END-BGN) as # of Days   
      
   How do I use QBE to do d) line  ???  :-)   
      
   TIA   
      
      
      
      
      
   "Tony McGuire"  wrote:   
   >   
   >I wanna know why Saturdays and/or Sundays aren't excluded in order to get   
      
   >job costing for days the job is actually being worked.   
   >   
   >   
   >---------------------------------------------------------   
   > Tony McGuire   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)