Confused about Summary Fields and Reporting
This is a very basic question, but for some reason I just cannot figure this out. Any help would be very much appreciated!
I have a Doctors Table with fields: DoctorID, DoctorName. I also have a Procedures table with fields: DoctorID, ProcedureName, ProcedureDate. They are linked using the "DoctorID" field. Each procedure that a doctor does is a record in the Procedures table.
I want to create a report for a user entered set of dates that summarizes procedure count by doctor. For example, if the user enters starting date "1/1/2011" and ending date "1/31/2011", then I want a report that looks like this:
I only want procedures to be included in the count if "ProcedureDate" falls between "StartingDate" and "EndingDate". How do I create this report?