swf Posted January 23, 2005 Share Posted January 23, 2005 I have been so far very successful in creating my database but I am having trouble in displaying a summary of my data in a report and would appreciate help. I have a database of patients each of whom have many visits by a physician. Patient A is seen on 1/1/05 by Dr Y, 1/2/05 by Dr Z, 1/3/05 by Dr X. The same is true of Patient B although the dates and doctors will vary. At the end of the month I want to make a spreadsheet report that has the patients in rows and day of the month in columns. If patient A was seen on 1/1 it will display Dr. Y in that cell. under 1/2 it will display Dr. Z in the cell. Again each patient is linked to many visits which record the date and the doctor for each one. Finally I want to be able to punch in the date range each month. 1st 1/1-1/30 then 2/1 to 2/28 etc. and create monthly summary reports. Any help is appreciated. SWF Link to comment Share on other sites More sharing options...
This topic is 6630 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now