G Guest Oct 31, 2007 #1 I have been trying to write a query to count the number of start dates for projects that have not started yet.
I have been trying to write a query to count the number of start dates for projects that have not started yet.
G Guest Oct 31, 2007 #2 Ok, do you have a ScheduleStart and ActualStart dates? Or just StartDate that is null before starting. If the latter then just count nulls. Expr1: IIF([StartDate] Is Null, 1, 0) and sum the field.
Ok, do you have a ScheduleStart and ActualStart dates? Or just StartDate that is null before starting. If the latter then just count nulls. Expr1: IIF([StartDate] Is Null, 1, 0) and sum the field.
