Report filtering

How to filter reports.

by Access Watch

| Mobile | click for more article services

Q: Sandy Salas writes to ask: I have a report that has several fields on the report that could be used as a filter. … Phase, Priority, Grouping, Open, Division… I may not use all of the filters might only need the first 2 but possible all of them. How can I filter a report by these fields?

A: One "quick and easy" solution would be to upgrade to Office 2007 -- Access 2007 has a great new report feature that allows interactive filtering and sorting of reports, without any code. If you aren't going to upgrade, see my Code Sample #26 (Sorting and Filtering Reports) for a way to filter reports, using an input form.

Article posted: Wednesday, 07 March 2007

there's more ...

If you liked this article you'll LOVE our new ebooks.

OFFICE 2013: the real startup guide Everything you need to know about Office 2013 but Microsoft won't tell you.

How to save money, install, configure and use the new features in Office 2013. Get it today - click here.

Windows 8 for Microsoft Office users A practical guide the new, changed and unfamiliar in Windows 8

A focused and unvarnished look at Windows 8, especially written for the many people who use Microsoft Office Get it today - click here.

ORGANIZING OUTLOOK EMAIL - tame your Outlook 2010 Inbox

100+ pages of practical tips and help to streamline, automate and search your Inbox. Get more than you ever thought possible from Outlook. Read it today - click here.

Article Services sponsored by: Office Watch Ebooks - available now to download and read today.

RSS feed for this category

Office Watch, Office for Mere Mortals, Access Watch and all titles used within the publications are Copyright © 1996-2013 Office Watch.
Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint and doubtless many other names are registered trademarks of Microsoft Corporation.
Search | Sitemap | Popular Topics | Privacy Statement | Advertising | Twitter | Feedback / Contact Us
Office Watch is definitely not affiliated with Microsoft - and that's just one reason why we are so useful to Microsoft Office users around the world J (Erko).