Project Duration

[Ian Frost]

I need to display either in a query or in a report the average number of days a project takes in each phase(Planning, design, constrution, completion) based on the project cost. Currently i have a query that displays the information below. (Just a sample) What i need to figure out is how to display the average #of days in each phase for a certain project cost interval. (ex. $0-$50, $51-$100, $101-$150)

Project Cost	Days in Planning	Days in Design	Days in Construction	Days to Completion
$100	20	42	100	162
$125	40	35	110	185
$50	25	37	105	167
$75	50	40	109	199
$145	25	50	130	205
$150	28	52	80	160
$60	15	58	92	165

[ranman256]

Build individ queries for each block w its new field

Q1 = select *,"$0-$50" as Block from tProject where [cost] between 0 and 50
Q2 = select *,"$51-$100" as Block from tProject where [cost] between 51 and 100
Q3 =... etc.

then put all of them in a UNION QUERY ,say: qnCostBlocks
select * from Q1
union
select * from Q2
union
select * from Q3 ...

Then run your averages off this query: qnCostBlocks

[hapm]

Lets say the interval is $50 you can simply group by Int(ProjectCost/50). Grouping would be from 0 to 49 ... If you want to have it from 0 to 50 you would need to use Int((ProjectCost-1)/50).