sorting and filtering and removing hidden records

**johnmerlino** · 10-04-2010, 10:01 PM

Hey all,

The below excel macro filters and sorts data BUT when I try to export the file, all the hidden cells return, even though I want the hidden cells destroyed:

Please Login or Register  to view this content.

Is there a way where I can sort and filter similarly in Access but not have the issue where all the filtered fields remain when I try to export the data or perform a query against other data sets without having to worry that the filtered criteria will make its presence again?

Thanks for response.

**alansidman** · 10-04-2010, 10:31 PM

If you run a query in Access, you select which fields you wish to display in your query. So if there are fields in your table that you do not wish to show in the query, then you either omit them from the query or if you need them for joining to another table, you just indicate that the field should not be displayed. If you then export the query results to Excel or some other software package, it will only export the displayed fields.

Alan

**johnmerlino** · 10-05-2010, 09:12 AM

The problem is there is a sequence of events. We must:

Please Login or Register  to view this content.

That's pretty much MySQL. I'm struggling how to do something like this in Access. I picked up an "essentials" book in access and it shows you the design view where you can specify criteria for particular fields, but it's not giving me an impression of a sequence of events where you do something and then something else.

Thanks for response.

**alansidman** · 10-05-2010, 04:35 PM

Please Login or Register  to view this content.

I am not sure what you are alluding to here. Could you be more specific. If you are referring to running one query and then take action on that query and then take subsequent action on the second query, then you cannot do that all in one query. You will have to sequence your queries. This can be done in the QBE. Run your first query. Then create a second query which is based upon the first query and not on the original table(s). Do this until you get the expected results.

If I missed what you are looking for, post back with more information and perhaps with some sample data with expected results. That always helps to clear the matter.

Alan