Extracting data

  • Thread starter Thread starter arm
  • Start date Start date
A

arm

Hello! Could anyone please help me. I have this continuous form that uses
a query as its recordsource. From time to time I set the form's Filter &
FilterOn properties to display the data I want to view. My problem (after
setting Filter & FilterOn properties) is it possible to extract all the
records currently viewed from the form to a table or maybe to an excel file?
Thank you very much for the help. :-)
 
One way...
Apply the filters you want. View the form in datasheet
view. Select all the columns, copy, and paste into an
Excel worksheet.

If you want an Access table to hold the filtered results,
I think you'll have to work directly with the query and
turn it into a Make Table query. Maybe someone else knows
a way to get directly grom a form to a table.

Hope this helps.
 
Back
Top