I've got a query that contains a field Air_Dates, and a calculated field to find the Week Start Date of the Air_Date (week begins on Monday). The query field/calculation is:
Week: DateAdd("d",-Weekday([Air_Date],2)+1,[Air_Date]).
The query won't sort on that field, gives a data type mismatch error. The report I'm trying to develop groups on that calculated field Week and it also produces that error and won't run.
What can I do to reconcile this?
MIB1019
Week: DateAdd("d",-Weekday([Air_Date],2)+1,[Air_Date]).
The query won't sort on that field, gives a data type mismatch error. The report I'm trying to develop groups on that calculated field Week and it also produces that error and won't run.
What can I do to reconcile this?
MIB1019