Anyway to program a report that when you click on a field or label it will resort the report on that field while you're viewing the report?
Novice
Windows 8 
Access 2013
Anyway to program a report that when you click on a field or label it will resort the report on that field while you're viewing the report?
VIP
Windows 7 64bit Access 2010 32bit
Maybe in Report View, not Print Preview, and if there is no Sorting & Grouping setup. Reports are not intended to be interactive.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 8 Access 2013
Report looks better than a query. So was trying to see when I view a report if I could sort on different fields and have the report reload with that sort.
VIP
Windows 7 64bit Access 2010 32bit
Try what I suggested - Report View - and code to set the Order By property. I've never tried.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 8 Access 2013
You are correct that reports are for static view and not dynamic. Will have use a query view.
Who is John Galt?
Windows XP Access 2007
June suggested Report view, which is interactive. I have used it to let the user change the criteria and sorting on the fly. Most of us never let users in tables or queries directly.
Posting Permissions
Reply With Quote