jfwhite4
asked on
MS Access Query - Count across Multiple Fileds
I'm trying to create a query in MS Access that provides a count for multiple field of the data that fints into certain ranges.
Table looks like this: (dummy data)
budget, actual, estimated, proposed
$50, $150, $160, $155
$40, $350, $140, $255
$250, $250, $110, $115
$450, $250, $260, $55
The query result should look like this: Or it could have the ranges across the top.
The query gives a count for each field of the values that meet the criteria on the left.
RANGE, budget, actual, estimated, proposed
<=$100: 2, 0, 0, 1
>$100 & <=$200: 0,0,2,2
>$200 & <=$300: 1,2,1,1
>$300: 1,1,0,0
Table looks like this: (dummy data)
budget, actual, estimated, proposed
$50, $150, $160, $155
$40, $350, $140, $255
$250, $250, $110, $115
$450, $250, $260, $55
The query result should look like this: Or it could have the ranges across the top.
The query gives a count for each field of the values that meet the criteria on the left.
RANGE, budget, actual, estimated, proposed
<=$100: 2, 0, 0, 1
>$100 & <=$200: 0,0,2,2
>$200 & <=$300: 1,2,1,1
>$300: 1,1,0,0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.