If you're using a SQL SELECT statement to generate a cursor that is used for the Daily Report, make the WHERE statement something like this:

WHERE ApptDate = DATE()

or you could default a RptDate variable or form variable to the current date, but allow the user to change it so they could get a Daily Report for tomorrow. In that case the code would be more like this:

WHERE ApptDate = Thisform.RptDate


Hope this helps,

Russell Campbell



>Sir excuse me po...
> I have an Appointment table where there is an appointment date, patient name , time , treatment... for example I have 2 appointment date , one is March 13 and one is March 14. How can my Daily Report contain only the appoint ment on March 13 because today is March 13? Hope You could help me with this .. tnx u very much.