Allow users to pick sorting order on a report

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have an input for that has fields such as PatientName,
DoctorName, VisitDate, TestNumber, InvoiceNumber and
InvoiceDate, InvoicePaid, Amount, Type and three or four
more fields.. Right now this form is based on a query
called LabTestQuery which is based on a table called
LabTests. It is sorted by PatientName. There are
several people who us it to enter information.

What I would like to do is to create a seperate report
based on this information but with a combo box that
allows the user to select how they want the report
sorted. Since there are about a dozen fields in total, I
would rather not create 12 different reports with
different sorting orders. Is there a way to create one
report that allows a user to select the sorting order?

Thanks,

Chuck
 
Back
Top