Unable to save Filter as a query in access

[mysteryboy]

Hi,

Iam new to access need some help to solve this, iam unable to save filtered condition as a query in access. when i click on file > save as option i have only three list i can choose from Form,Report and data access page . I want to save the condition as a query which iam unable to do. Any help in this would be appreciated

Thank u

 

[ahuvas]

If I understand you correctly you have created a query to filter data and u are trying to save the filtered data as a new table?

If you are trying to create a query as a filter you cant actually save the data in the filtered state - the filter is like a window shade that only lets you see part of what is going on but doesnt affect what is going on inside the house.

To build a query you should do it in the query builder section of access. When you close a new query it will ask you for a query name.