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
 
Back
Top