Problems printing reports in 2003 MS Access

  • Thread starter Thread starter susiewng
  • Start date Start date
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!
 
Presumably you print out a report?

Open the report in design view.
Open the Sorting And Grouping dialog.
Choose the field you want to sort on there.
 
Back
Top