S
susiewng
Help! I recently created a patient database for a medical clinic. The
database was designed so that users could enter patient info on a form
and then print out the entered data in a report. Each new patient
because a new "page" in the report printout. Just recently, I became
aware that the patient reports were not being displayed in
chronological order (Patient #18 is followed by Patient #26, etc),
which makes printing out recently entered reports difficult.
I've tried a number of possible solutions: sorting by ascending date/
tim, removing any possible filters, adding an autonumber column to my
tables/forms/reports, sorting by autonumber, and creating a "print
report" button on the patient form (which prints out reports on *all*
entered patients). All of these were futile, and I still kept viewing
reports in seemingly random order. I'm out of ideas and am wondering
if anyone has any suggestions on what is going on and how I can fix my
database?
Thank you!
database was designed so that users could enter patient info on a form
and then print out the entered data in a report. Each new patient
because a new "page" in the report printout. Just recently, I became
aware that the patient reports were not being displayed in
chronological order (Patient #18 is followed by Patient #26, etc),
which makes printing out recently entered reports difficult.
I've tried a number of possible solutions: sorting by ascending date/
tim, removing any possible filters, adding an autonumber column to my
tables/forms/reports, sorting by autonumber, and creating a "print
report" button on the patient form (which prints out reports on *all*
entered patients). All of these were futile, and I still kept viewing
reports in seemingly random order. I'm out of ideas and am wondering
if anyone has any suggestions on what is going on and how I can fix my
database?
Thank you!