Hi,
Just curious. Is there a way to add a created field to another field in a crosstab query ?
I've created a field called
This gives me a date on which I can expect my invoice to be paid.
When I want to use this date to distinguish what Financial Year it falls I am using this :
When running I get the error : The Microsoft Access database engine does not recognize '[Expected]' as a valid field name or expression
I guess I could put the Expected formula everytime it is mentioned in the FY field, but that feels messy.
I've definitely had it work that the fields used in the query are immediately available in the Builder>Expression Categories section.
Any advice ?
Just curious. Is there a way to add a created field to another field in a crosstab query ?
I've created a field called
Code:
Expected: DateAdd("d",Nz([DaysToPay],30)+Left([terms],2),[ScheduledDate])
When I want to use this date to distinguish what Financial Year it falls I am using this :
Code:
FY: IIf(Month([Expected])>=4,Year([Expected]) & "-" & Right(Year([Expected])+1,2),Year([Expected])-1 & "-" & Right(Year([Expected]),2))
When running I get the error : The Microsoft Access database engine does not recognize '[Expected]' as a valid field name or expression
I guess I could put the Expected formula everytime it is mentioned in the FY field, but that feels messy.
I've definitely had it work that the fields used in the query are immediately available in the Builder>Expression Categories section.
Any advice ?