hi,
i have a table where I mark attendance, with field names as name, id, 1-mar, 2-mar, 3-mar, 4-mar and so on. how do i create a query where if for 2 continious days the attendance marked is "Leave", then the query pulls the names out in a different table and shows the days also and if after that if the attendance marked is "present" then the name does not show up.
Rajat