Filter by today date but not in First Table to Second Table

[DGRAJ]

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(Auto Number), UserID(Number), State(Text),Att _Date(Date/Time)

Template Fields = TemplateID(Auto Number),UserID( Number),Full_Na me(Text),Age(Nu mber)

Absent Fields = TemplateID(Auto Number), UserID(Number), State(Text),Att _Date(Date/Time)

[Rabbit]

To find what rows are missing from one table to another, you can use an outer join and look for nulls on the key fields.

[zmbd]

This doesn't seem to be normalized either; however, that's based on very limited information.