Hi everyone
I am getting error while running the query
It have two tables the table for attendance data from Microsoft Teams table name meetingAttendanceList
The other table is student master table st_mstr ,
I am unable to eliminate the duplicate when i run query because of multiple records for a student joined and left
and other problem when i run the same query (qry group and date) there is a formula to extract date from text field also not able to get the correct report for a particular date and group dates are mixed up
attached sample file