Save a filter (from table) as a query

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

I opened a table and used the filter key twice, how do I
now save that information as a query? The only options
in the drop down box for saving are
form, report or access page.

Also, when using the filtered method, do I ever run the
risk of altering my original table and losing all the
information? I have Access 2002.
 
No shortcuts, sorry. You can open the table in design mode and open the
property sheet to copy the filter property. this will be placed in the
criteria field of the query builder or the WHERE clause of the query.
Example:
table BucketMaterial
Filter ((BucketMaterial.BucketMaterial="Stainless"))
query SELECT * FROM BucketMaterial WHERE
((BucketMaterial.BucketMaterial="Stainless"))
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Criteria Not Working 2
AND query 4
Filtering a table by using criteria in another table 1
passthrough query referencing a saved table 1
Using Filter by Form to create a Query and then a Report 6
Closing Queries automatically saves them 6
Filter query with checkboxes 0
joined tables in query, will not filter "no" properly 1

Back
Top