iss thiss possssible?

[MOHAMMED HAFEEZ M.K.]

Hello:
I have a view created from two tables staff and date.The view has the following fields the staffid,name and the date of the exam. The problem is i want to display a result in a table which contains the staff names as column against which there is dates during which the staffs will have duty.the format is as follows:

staffname; date1(am/pm) : date2(am/pm) : date3(am/pm) : date4(am/pm)..........
asok : tick : tick : :
lalit : : tick : t ick
joseph : tick tick : tick
.........:
...........
.........


the tick(represents the duty) of the staff on that date(can be am/pm). the number of duties assigned to the staff should be equal.(depends onn umber of candidates/room=30 and staff assigned =1 on that date)

[JohnDoe]

Bit confused as to what your trying to achieve. More details please?