I'm working on a little attendance system.No record is entered for
absent . Now if I want to see who was absent ?
I've to display the absentees as well ..
does any body out there have a clue how to do this

I would enter a record for an absent person, this is how I would handle it.

1..I would have a table called status, design view:
Id (PK)
type (varchar)
inactive (bit)
View table content:
1 Present 0
2 Sick 0
3 Leave 0
4 Absent 0

2..Now in your main table where you record attendence details create a field called statusID (INT - no nulls) this is a forign key that relates to the status tables primary key (ID).

3..On your attendence web form select all entries from the status tble where inactive = false. choose and submit the appropriate status.

Wind is your friend
Matt