View Single Post
  #1 (permalink)  
Old August 27th, 2008, 08:03 AM
firefighter2045 firefighter2045 is offline
Authorized User
 
Join Date: Oct 2007
Location: , , .
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default Selecting records in a query

I have a query with 5 fields: FabUnit, Priority, GskHours, Balance, and TimeToCMP

What I would like to do is select all the records for each FabUnit sorted ascending by Priority where the sum of TimeToCMP would be less than or equal to 40, the next record would make the sum greater than 40.

I don’t want to actually sum the records I just want to select the records with the query, I was wondering if there was a Select statement that I could put in the criteria field of the query to do this.


Thanks
Tony


Reply With Quote