Hi all,
Presently I have a summary report that uses control source statements to put results on the report, but suddenly I'm receiving this infamous error message:
"The expression is typed incorrection, or is too complex to be evaluated..."
So I'm looking for some help in converting the control source statements into a query that will produce the same summary report results. What I'm not sure how to do is create various output information based on differing criteria, all within the same query.
For example, here are 3 of the the control statements from the report:
=Sum(Abs(Year([RecDate])=Year(Date()) And ([NotifType]=9)))
=Sum(Abs(([RecDate] Between [Forms]![frmRptCriteria]![txtBeginDate] And [Forms]![frmRptCriteria]![txtEndDate]) And [NotifType]=9))
=Sum(Abs(Year([RecDate])=(Year(Date())) And ([RespType]=26)))
There are 10 more.
Like I said, I'm used to filtering data in queries, not creating calculations based on criteria, so I don't understand how to build all of these seperate expressions within the same query. I would greatly appreicate some help with this, at least to get me started.
Thank you,
Kerry
Presently I have a summary report that uses control source statements to put results on the report, but suddenly I'm receiving this infamous error message:
"The expression is typed incorrection, or is too complex to be evaluated..."
So I'm looking for some help in converting the control source statements into a query that will produce the same summary report results. What I'm not sure how to do is create various output information based on differing criteria, all within the same query.
For example, here are 3 of the the control statements from the report:
=Sum(Abs(Year([RecDate])=Year(Date()) And ([NotifType]=9)))
=Sum(Abs(([RecDate] Between [Forms]![frmRptCriteria]![txtBeginDate] And [Forms]![frmRptCriteria]![txtEndDate]) And [NotifType]=9))
=Sum(Abs(Year([RecDate])=(Year(Date())) And ([RespType]=26)))
There are 10 more.
Like I said, I'm used to filtering data in queries, not creating calculations based on criteria, so I don't understand how to build all of these seperate expressions within the same query. I would greatly appreicate some help with this, at least to get me started.
Thank you,
Kerry
Last edited:
