So, I guess I can't do this. I have calculated fields in my table (DateAddW) and I'm trying to create more calculated fields based on those calculated fields, but it seems it can't be done.
Is there a better way?
I don't really understand functions so I need all the help I can get!!!
What I'm trying to do is something like this:
Field 1 - Type
Field 2 - Date received
Field 3 - Date Processed
Field 4 - Projected Date Processed: IIf(Not IsNull[Date Processed]),"",IIf([Type]=x,DateAddW([Date Processed],5),IIf([Type]=y,DateAddW([Date Processed],15))))
Field 5 - Date Filed
Field 6 - Projected Date Filed: IIf(Not IsNull[Date Filed]),"",DateAddW([Projected Date Processed],30)))
Field 7 - Date Approved
Field 8 - Projected Date Approved: IIf(Not IsNull[Date Approved]),"",IIf([Type]=x,DateAddW([Projected Date Filed],45),IIf([Type]=y,DateAddW(Projected Date Filed],30))))
Etc.
I can make it work in a form, but then I can't write queries based on the calculated fields from it. Sigh.
HELP!!!!
Is there a better way?
I don't really understand functions so I need all the help I can get!!!
What I'm trying to do is something like this:
Field 1 - Type
Field 2 - Date received
Field 3 - Date Processed
Field 4 - Projected Date Processed: IIf(Not IsNull[Date Processed]),"",IIf([Type]=x,DateAddW([Date Processed],5),IIf([Type]=y,DateAddW([Date Processed],15))))
Field 5 - Date Filed
Field 6 - Projected Date Filed: IIf(Not IsNull[Date Filed]),"",DateAddW([Projected Date Processed],30)))
Field 7 - Date Approved
Field 8 - Projected Date Approved: IIf(Not IsNull[Date Approved]),"",IIf([Type]=x,DateAddW([Projected Date Filed],45),IIf([Type]=y,DateAddW(Projected Date Filed],30))))
Etc.
I can make it work in a form, but then I can't write queries based on the calculated fields from it. Sigh.
HELP!!!!