Check if that person is absent

[s4]

Hey, I have a report that has the day/date down the left, and the columns
following have names of people. I have a seperate table with 'start' and
'end' dates, and a person's name. Is there an expression to check if a person
is listed in table2 with the date on the left falling between start and end?
I'd like to use this in conditional formatting to highlight that that person
is absent.It looks sorta like:~DATE~~PERSON1~~PERSON2~~PERSON3~~PERSON4~So
say the date was the 21/06/08 and person2's name cropped up in the other
table with a start of 01/06/08 and an end of 30/06/08 then they would be
flagged because on that day they are in the second table. Hope this makes
some sense.Thanks

 

[pietlinden]

Hey, I have a report that has the day/date down the left, and the columns
following have names of people. I have a seperate table with 'start' and
'end' dates, and a person's name. Is there an expression to check if a person
is listed in table2 with the date on the left falling between start and end?
I'd like to use this in conditional formatting to highlight that that person
is absent.It looks sorta like:~DATE~~PERSON1~~PERSON2~~PERSON3~~PERSON4~So
say the date was the 21/06/08 and person2's name cropped up in the other
table with a start of 01/06/08 and an end of 30/06/08 then they would be
flagged because on that day they are in the second table. Hope this makes
some sense.Thanks

proper structure is more like this:

Person(PersonID, Name...)
Attendance(PersonID, AttendDate, Present (yes/no))
Dates(AttendDate)

Then you can just query the easy way. Either present=Yes (one option)
or there is a record (PersonID, AttendDate) in the Attendance table.