Saving Filter Results

[jaaron29]

I'm going to try NOT to post every week....

What I need to know is how can you save your filtered results. I know how to apply the filter, view, return to original results, etc.

How do you save the filtered results; can you save within the table, within a query?

Again, any help is appreciated...

Thanks, Toni

 

[doran_doran]

data retrieval

Are you trying to retrieve certain data that you being filtered to a form? If yes, you don't wanna save filtered data b/c very soon your database will be full of junk records.

Try put a search form and then use itemselect method to pull up that particular record in another form.

You can do a search for how to make a search form. There are tons of help here.

GOOD LUCK.
Dianna Jamil

 

[jaaron29]

No, this is not being used for form creation or the like. Just viewing the filtered results, and wanting to save the results...that's it...nothing fancy...

 

[dcx693]

No, there is no simple way to achieve what you want with just a table. I suggest creating a new query for each different view of the data you want. They take up minimal space.

If you want to save multiple views of your data and would like to toggle between them quickly, you need to create a form that will set the queries to be the recordsource of the form.