I have a student attendance form which opens showing all students who are currently enrolled.
On the form there are 3 filters for Form_Filt (for the class name), Filt_Yr and Filt_AttCode.
For Example, I might want to update attendance for Class "MS78A" (Which is made up of students from 2 year levels)
Or perhaps I want to update all the year 8's only
Or perhaps only those students that belong to a specific AttendanceCode
I might want to update a combination of these fields.
The user selects the fields that they want to filter by, and then they click a button which applies a filter to the data shown on screen.
It is also possible (but highly unlikely) that the user simply wants to insert a record for each student, in which case, they would not apply the filter.
Now I want the user to press another button (called "Insert Attendance") which will add an attendance record for each of the filtered records.
I tried creating an insert query with the following condition on the ClassName field
IIf(Not IsNull([Forms]![FRM_ATT_BulkUpdate]![Form_Filt]),[Forms]![FRM_ATT_BulkUpdate]![Form_Filt],"alike *")
but Access tells me that the query is too complex to be evaluated.
How can I create a query which selects the filtered information (if applicable) only?
On the form there are 3 filters for Form_Filt (for the class name), Filt_Yr and Filt_AttCode.
For Example, I might want to update attendance for Class "MS78A" (Which is made up of students from 2 year levels)
Or perhaps I want to update all the year 8's only
Or perhaps only those students that belong to a specific AttendanceCode
I might want to update a combination of these fields.
The user selects the fields that they want to filter by, and then they click a button which applies a filter to the data shown on screen.
It is also possible (but highly unlikely) that the user simply wants to insert a record for each student, in which case, they would not apply the filter.
Now I want the user to press another button (called "Insert Attendance") which will add an attendance record for each of the filtered records.
I tried creating an insert query with the following condition on the ClassName field
IIf(Not IsNull([Forms]![FRM_ATT_BulkUpdate]![Form_Filt]),[Forms]![FRM_ATT_BulkUpdate]![Form_Filt],"alike *")
but Access tells me that the query is too complex to be evaluated.
How can I create a query which selects the filtered information (if applicable) only?
