I have the following expression in a Totals query. The error message I'm getting is "This expression is typed incorrectly or is too complicated to be evaluated...."
12MoChgs: DSum("[Charges]","[AR_Rec]","[Month]">=(DateAdd("m",-11,[Forms]![frmAR_RecDialog]![RptMonth]) And "[Month]"<=[Forms]![frmAR_RecDialog]![RptMonth]))
In plain english, I'm trying to sum all charges over a 12 month period - beginning with the current (selected) report month.
Any help would be greatly appreciated!!!
12MoChgs: DSum("[Charges]","[AR_Rec]","[Month]">=(DateAdd("m",-11,[Forms]![frmAR_RecDialog]![RptMonth]) And "[Month]"<=[Forms]![frmAR_RecDialog]![RptMonth]))
In plain english, I'm trying to sum all charges over a 12 month period - beginning with the current (selected) report month.
Any help would be greatly appreciated!!!