Multiple Filter/Sorts in a Report via Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my database, I have a report requiring the user to enter in a sort
criteria of a persons name and the priority level of the case. The name sort
works but the priority level sort does not. This report was created using a
query. This entire database was created by another individual who is gone.
How do you get more then one sort/filter option to work?
 
Does the query work by itself without the report? If so then you'd have to
check grouping and sorting properties in the report. If the query doesn't
work Then we'd need to see the query to help. That is the best I can do with
the info given.
 
"sorting" generally refers to the order the records appear. I assume you
mean to filter or limit the records that appear.

Can you provide some information on how the filtering is applied? It might
help if we could see the SQL view of the report's record source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access2007: CustomReport - User entered Sort order 0
Coordinating the sort order in a report with the underlying query 2
How to select filter data for Report? 1
Grouping and Sorting a Report On Open Event 3
Report Sorting 1
Report sorting when selection criteria via form 1
concatenated field in a report is not sorted 1
Changing Sort Order On Report Programatically 2

Back
Top