I am trying to open an access report based on two criteria on my form. here is the macro i am using.
for a single criteria it is working fine. but i am unable to add multple criteria for report. Here is the code i wrote for multiple criteria.
dateS is a textbox with date picker
clasS is a CBO with values in it.
the result i am looking for is that the user select a date and class and the report prints/displays data based on these two queries.
Code:
="atdate = '" & [Forms]![Student_Attendance]![dateS] & "'"
for a single criteria it is working fine. but i am unable to add multple criteria for report. Here is the code i wrote for multiple criteria.
Code:
="atdate = '" & [Forms]![Student_Attendance]![dateS] & "'" And ="atdate = '" & [Forms]![Student_Attendance]![clasS].value & "'"
dateS is a textbox with date picker
clasS is a CBO with values in it.
the result i am looking for is that the user select a date and class and the report prints/displays data based on these two queries.