J
JesseM
I hope this question isn't too basic. I created a report with a chart based
on a query. I would like to update the values on the chart based on a date
range and whether maintenance agreement was in effect. The form for the date
range criteria works but for some reason when I add the combo box options as
criteria in the query I get an error message - "This expression is typed
incorrectly, or it is too complex to be evaluated. For example, a numeric
expression may contain too many complicated elements. Try simplifying the
expression by assigning parts of the expression to variables."
The criteria in the query for the dates is
The criteria for the combo box with the Yes/No field in the main form is
=[Forms]![frmMaintagronChart]![cboMaintAgr]
My combo choices are "Yes", "No", " ". I started trying it with a group
choice but that seemed to get even more complicated. Any ideas?
on a query. I would like to update the values on the chart based on a date
range and whether maintenance agreement was in effect. The form for the date
range criteria works but for some reason when I add the combo box options as
criteria in the query I get an error message - "This expression is typed
incorrectly, or it is too complex to be evaluated. For example, a numeric
expression may contain too many complicated elements. Try simplifying the
expression by assigning parts of the expression to variables."
The criteria in the query for the dates is
=[Forms]![diaDateRange]![txtStartdate]<=[Forms]![diaDateRange]![txtEnddate]
The criteria for the combo box with the Yes/No field in the main form is
=[Forms]![frmMaintagronChart]![cboMaintAgr]
My combo choices are "Yes", "No", " ". I started trying it with a group
choice but that seemed to get even more complicated. Any ideas?