Hi I have Three Table First Table Name Is Attandance, Second is Template And Third is Absent i want to filter which data not in Attandance filter by Only Today Date from Template table and i don't want old dated User ID and Insert in Absent Table
Table Details
Attandance Fields = TemplateID(AutoNumber), UserID(Number),State(Text),Att_Date(Date/Time)
Template Fields = TemplateID(AutoNumber),UserID(Number),Full_Name(Te xt),Age(Number)
Absent Fields = TemplateID(AutoNumber), UserID(Number),State(Text),Att_Date(Date/Time)