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.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<susiewng@gmail.com> wrote in message
news:f3ce9918-4668-4931-b754-ab5cdca27001@v3g2000hsc.googlegroups.com...
> 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!