J
JT
Dear all
I have a data field which contains a mixture of date entries and text
entries which read either "ongoing" or "missing".
I use the following function to convert the date entries into the "yyyy mm"
format in a query:
End date: IIf([Provision end date]="missing","missing",IIf([Provision end
date]="ongoing","ongoing",Format(Val([Provision end date]),"yyyy mm")))
In a subsequent query I then attempt to group data based on this End date,
but this results in a "Data type mismatch in criteria expression" error.
I have no idea why I cannot group data in this way and haven't been able to
find a solution elsewhere in this group.
Thanks
John
I have a data field which contains a mixture of date entries and text
entries which read either "ongoing" or "missing".
I use the following function to convert the date entries into the "yyyy mm"
format in a query:
End date: IIf([Provision end date]="missing","missing",IIf([Provision end
date]="ongoing","ongoing",Format(Val([Provision end date]),"yyyy mm")))
In a subsequent query I then attempt to group data based on this End date,
but this results in a "Data type mismatch in criteria expression" error.
I have no idea why I cannot group data in this way and haven't been able to
find a solution elsewhere in this group.
Thanks
John