Looking for help

[Unicon]

Hi I have a time sheet database (attached) I just want to design report like report (attachment report). I tried a lot but unable to do that. I just want to show those ID no's only in report who was entered as "N" and "OT" in attendance field.

Please advise.

Looking for your favourable reponse as always.

 

[DCrake]

This is achievable using a crosstab query Look for examples on the site.

 

[Unicon]

DCrake thanks a lot but I don't have an Idea how to do that.

Please advise.