drshahriyar said:
thanks for the quick reply. i am a novice in access and therefore unable to understand what you said. could you give me more details.
Your report uses a Record Source (which you can find in its properties when you are in Report View for the report) You need to create a query or change the one already there to look like this and use that as the record source. That way, the report will know exactly what to well ... report.
To find the record source. right-click on the open report and change it to REPORT VIEW, then right-click again and select PROPERTIES. Once in properties click on DATA. the first choice there should be RECORD SOURCE. Something should be in that box. Click in the box and then on the three dots. That should bring up the query in SQL.
SELECT Yourtable.*
(is the name of the table that the form uses for its fields. In the above statement you are asking it to select all the fields in the table)
FROM YourTable
(This is telling it what table to look in for these fields)
WHERE YourDateField = Forms!YourForm!YourControlName
(YourDatefield is the field in the table that refers to the operation date)
(YourForm is the name that you gave the form that you referred to in your original post)
(YourControlName is the name of the textbox in your form that holds the operation date)
ORDER BY YourDateField, YourPatientNameField;
YourPatientNameField is the name of the field in your table that refers to the patient)
(This tells the query to put the results in date order and then in alphabetical order by name within that date)
I can't get much more detailed than this. I hope it helps to point you in the right direction.
