I have a query that has a couple derived fields:
F65Due: Format(DateSerial([Year],[FiscalEndMM]+7,0),"mm/dd/yyyy")
Status: IIf([received]>[F65Due],"LATE",IIf([received]<[F65Due],"TIMELY"))
What I want to do it pull those F65Due dates of say 9/30/06 as well a Status of LATE.
I'm not sure its possible
F65Due: Format(DateSerial([Year],[FiscalEndMM]+7,0),"mm/dd/yyyy")
Status: IIf([received]>[F65Due],"LATE",IIf([received]<[F65Due],"TIMELY"))
What I want to do it pull those F65Due dates of say 9/30/06 as well a Status of LATE.
I'm not sure its possible