I'm getting the error 3071 when selecting expressions containing such as < 10 or >10 in an unbound combo field in an unbound "criteria form" set to filter a field in a query that contains integers. When I open the query in Design view, remove the build from the Criteria that links that field in the query to the combo field on the form, and then type in the expression <10, or >10 as the Criteria for that field, it works fine. Also, if I type a value, without any expression such as < or > into the combo field on the form, the query filters successfully on that value. The 3071 error occurs only when I attempt to filter by way of the "criteria form".where the conditions of < or > are used in the expression.
Here is the SQL from that query:
SELECT STUDENT_DISCIPLINE_ANALYSIS.SCH, STUDENT_DISCIPLINE_ANALYSIS.STUDENT_ID, STUDENT_DISCIPLINE_ANALYSIS.GEN, STUDENT_DISCIPLINE_ANALYSIS.GRD, STUDENT_DISCIPLINE_ANALYSIS.H, STUDENT_DISCIPLINE_ANALYSIS.I, STUDENT_DISCIPLINE_ANALYSIS.A, STUDENT_DISCIPLINE_ANALYSIS.B, STUDENT_DISCIPLINE_ANALYSIS.P, STUDENT_DISCIPLINE_ANALYSIS.W, STUDENT_DISCIPLINE_ANALYSIS.PRIMRY_AREA, STUDENT_DISCIPLINE_ANALYSIS.ACTION_CD, STUDENT_DISCIPLINE_ANALYSIS.CountOfSTUDENT_ID, STUDENT_DISCIPLINE_ANALYSIS.SumOfAUXILIARY_CODE
FROM STUDENT_DISCIPLINE_ANALYSIS
WHERE (((STUDENT_DISCIPLINE_ANALYSIS.H)=[Forms]![DISCIPLINE_ANALYSIS]![Cmb_HISPANIC]) AND ((STUDENT_DISCIPLINE_ANALYSIS.I)=[Forms]![DISCIPLINE_ANALYSIS]![Cmb_INDIAN]) AND ((STUDENT_DISCIPLINE_ANALYSIS.A)=[Forms]![DISCIPLINE_ANALYSIS]![Cmb_ASIAN]) AND ((STUDENT_DISCIPLINE_ANALYSIS.B)=[Forms]![DISCIPLINE_ANALYSIS]![Cmb_BLACK]) AND ((STUDENT_DISCIPLINE_ANALYSIS.P)=[Forms]![DISCIPLINE_ANALYSIS]![Cmb_PACIFIC]) AND ((STUDENT_DISCIPLINE_ANALYSIS.W)=[Forms]![DISCIPLINE_ANALYSIS]![Cmb_WHITE]) AND ((STUDENT_DISCIPLINE_ANALYSIS.ACTION_CD)=[Forms]![DISCIPLINE_ANALYSIS]![Cmb_DISCIPLINE_ACTION]) AND ((STUDENT_DISCIPLINE_ANALYSIS.SumOfAUXILIARY_CODE) =[Forms]![DISCIPLINE_ANALYSIS]![Cmb_TOTAL_DAYS]));
Thanks in advance