Thread: Query issue
View Single Post
  #1 (permalink)  
Old June 3rd, 2008, 09:37 AM
jeremy1048 jeremy1048 is offline
Authorized User
Join Date: May 2007
Location: , , .
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query issue

I've messed around with this for a while and still no joys. I am trying to get access 2000 to bring out the right results

For each employee select the 67th percentile value of ascending ordered field of orders placed between certain dates.

the date field criteria is normally "BETWEEEN Date() and Date()-365" or "BETWEEN Date() and Date()-180"

the fields are

intcaseid this field only appeared as a check on what access was doing

I only want 1 result for each employee so the resultant would look like

J Bloggs 8.9%
A Smith 10.1%
A Other 7.5%
S Butts 6.9%

If I run the query with a specified employeeid e.g. "WHERE employeeid=5", I get a very different result if I group on employeeid.

E.g. I get grouped "J Bloggs 7.5%" and specific "J. Bloggs 8.9%"

Reply With Quote