about help in filtering

R

Renato Bacani

i have a database for students and it has a thousand entries...what should i
do for example if i want to see all Lastnames starts with letter A?.....so i
can avoid scrolling the entire database?..please help...thanks
 
D

Dirk Goldgar

In
Renato Bacani said:
i have a database for students and it has a thousand entries...what
should i do for example if i want to see all Lastnames starts with
letter A?.....so i can avoid scrolling the entire database?..please
help...thanks

Right-click in the LastName field. In the popup menu, type "A*"
(without the surrounding quotes) in the box beside the "Filter For:"
menu item. When you want to remove this filter, you can use the
right-click menu again, choosing "Remove Filter/Sort", or click the
Remove Filter button on the Access tool bar.
 
Y

Yumex85

yup
just as Dirk said,

or u can come up with a sql query like

select * from [students_table] where [lastname_column] like "a*"




yumi
 
Top