about help in filtering

[Guest]

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

 

[Dirk Goldgar]

In

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.

 

[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