Create a filter on a table

  • Thread starter Olivier Goossens Bara
  • Start date
O

Olivier Goossens Bara

Hello,
My question is probably trivial but I want to know if there is an quick way
to apply a filter on a table to only see the records corresponding to that
table ?
Of course I can define a query an run it but it does'nt seems to be the
easiest way. My purpose is not to define hundred of different query but just
sometime have a quick way to isolate some records as you can do when
filtering Excell tables for example.
Is it possible in Access ?
 
B

Brian

Olivier Goossens Bara said:
Hello,
My question is probably trivial but I want to know if there is an quick way
to apply a filter on a table to only see the records corresponding to that
table ?
Of course I can define a query an run it but it does'nt seems to be the
easiest way. My purpose is not to define hundred of different query but just
sometime have a quick way to isolate some records as you can do when
filtering Excell tables for example.
Is it possible in Access ?
Click to expand...

It kind of depends on how sophisticated you want to get. The simplest way
is to open a table, right click the field you want to filter on, and use one
of the filtering options at the top on the pop-up menu.
 
O

Olivier Goossens Bara

Thank you Brian

Indeed...

I was trying to do that on the top of the column in the Field Name area
It is not obvious to find option related to an whole column in a field
area...
 
Top