Quote Originally Posted by biit View Post
Thanks :-)

yes but my prob is if i put a count on tbl_patient where gender = male.. it returns the no of all the male patient rather than those males who came on a particular date..
You may add an : AND {Table.Date} = {?particulardate} to the Count condition

JG