Is it possible to Sort, filter, save as .csv

[JohnW]

I hope I've got the right group.
Is it possible to macro the following:
1. Sort a table by field - e.g. "Pets_Owned"
2. Filter all occurences to a seperate file - e.g. "Dogs" or "Cats"
3. Save this file as a .csv - e.g. dogs.csv or cats.csv
4. Without having to enter the search and save as criteria.

Any suggestions would be helpful.

I have a table with about 5000 records that will be broken into 145 files
for distribution and I really dont want to wear out my keyboard.

Thankyou in advance.

 

[Wayne-I-M]

Hi JOhn

1. Sort a table by field - e.g. "Pets_Owned"

Create a query based on the table and sort that.

2. Filter all occurences to a seperate file - e.g. "Dogs" or "Cats"

Create another query and Like "Dogs" or Like "Cats" in the criteria row

3. Save this file as a .csv - e.g. dogs.csv or cats.csv

Use output object - select the format from the dropdown

4. Without having to enter the search and save as criteria.

Run the export from the filter query (Like "Dogs" etc etc)

 

[JohnW]

Thanks for your help Wayne,
There's still some operator input in your suggestion, I was hoping there'd
be a simpler method.
I think I may have over simplified my original explanation, the sort
criteria is actually store codes (145 different that follow no patern).

I might have to export the sorted table to a file and split it with notepad
- yuk
Thanks anyway
Regards,
JohnW