How can I export only filtered ms access form data to excel?

Microsoft Office 2013 professional produ...
August 28, 2017 at 08:15:26
Specs: Windows 7
Hi,
I created a form that allows users to filter records and with a click of a button displays filtered data in a report. If no filter is selected, the report shows everything. So far, it’s working as planned. However, I’m struggling to export the filtered data to excel. My attempt exports everything. Any suggestions?
My form is based on MyQuery which consists of multiple tables.

TIA,


See More: How can I export only filtered ms access form data to excel?

Reply ↓  Report •

#1
Reply ↓  Report •

#2
August 29, 2017 at 05:51:14
Thanks for providing the link. However, this does not have the ability to filter records.
The problem is that the export gives me everything (not the filtered records).

TIA


Reply ↓  Report •
Related Solutions


Ask Question