Simply Filter Question

M

MB

When I run a query, the "apply a filter" button is greyed
out. Why is that? I want to filter by department.
Fields are EmployeeName, Department, Course.

I am running Access 2002 on XP.

MB
 
B

Bruce M. Thompson

When I run a query, the "apply a filter" button is greyed
out. Why is that? I want to filter by department.
Fields are EmployeeName, Department, Course.

I am running Access 2002 on XP.

You can't apply a filter if it doesn't yet exist. While the query is open in
datasheet view, you can go to "Records, Filter, Advanced Filter/Sort..." and
define a filter, then, while your filter definition is still open, click on the
"Apply Filter" button. Save the query to make the filter permanent.
 
M

MB

THANK YOU, Bruce! As you can well tell, I'm still
learning Access and have a LONG road ahead.
 
B

Bruce M. Thompson

THANK YOU, Bruce! As you can well tell, I'm still
learning Access and have a LONG road ahead.

As far as I know, we're ALL still learning Access. :)
 

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

Top