E Evenflow Registered User. Local time Today, 00:07 Joined Apr 13, 2005 Messages 22 May 16, 2005 #1 Hello, I have the following criteria for my Query >=0.8*[Projects]![EstimatedHours]. This tells me when we've used 80% of our actual hours. How would I go about the criteria line if I wanted it to return above >= 50% hour use, but below 80%? Thanks
Hello, I have the following criteria for my Query >=0.8*[Projects]![EstimatedHours]. This tells me when we've used 80% of our actual hours. How would I go about the criteria line if I wanted it to return above >= 50% hour use, but below 80%? Thanks
Brianwarnock Retired Local time Today, 05:07 Joined Jun 2, 2003 Messages 12,701 May 16, 2005 #2 you mean >=0.5*... AND <0.8*..... Brian