R
RobVT
Hello all,
Using Access 2003.
I have generated a database of construction production rates. Because
of the data collection techniques employed, I need to remove a certain
amount of the return data that can be identified as outliers. To do
this, I would like to prevent the top/bottom X% from being viewed, not
deleted outright.
Below is an example of the final query data return:
(Project Number) (Work Item Num) (Month Perf) (Mo Quantity) (Days Perf)
(Prod Rate (calc.))
001000 500 Jan 500 20 25
002000 500 Jan 1000 10 100
003000 500 Jan 2000 15 133
004000 500 Jan 15 10 1.5
001000 1000 Feb 60 3 20
etc.
As you can see, for each month and each work item, there can be
multiple records. What I need to do then, is sort through the list for
each month, remove the top and bottom X records, then return the data
to the user.
Is it possible to accomplish this with a query or VBA and still return
the data to the user in a MS Access Pivot Table?
Thanks in advance! All suggestions are welcomed!
Using Access 2003.
I have generated a database of construction production rates. Because
of the data collection techniques employed, I need to remove a certain
amount of the return data that can be identified as outliers. To do
this, I would like to prevent the top/bottom X% from being viewed, not
deleted outright.
Below is an example of the final query data return:
(Project Number) (Work Item Num) (Month Perf) (Mo Quantity) (Days Perf)
(Prod Rate (calc.))
001000 500 Jan 500 20 25
002000 500 Jan 1000 10 100
003000 500 Jan 2000 15 133
004000 500 Jan 15 10 1.5
001000 1000 Feb 60 3 20
etc.
As you can see, for each month and each work item, there can be
multiple records. What I need to do then, is sort through the list for
each month, remove the top and bottom X records, then return the data
to the user.
Is it possible to accomplish this with a query or VBA and still return
the data to the user in a MS Access Pivot Table?
Thanks in advance! All suggestions are welcomed!