how do i put less than or more than in data base that would show me the result for eg. >10 0r <10 how do

Question

this is for an asignment i need help on it
the question is list the studnets with more than 10 absent days for the academic year . it a query in database

Answer 1

In the query tables in design view, when you have dropped all the field titles in it, in the criteria box for the correct field (i assume you have one called absent days or something like that) you will need to type >10. Then save the query!! run the query and you will be shown all the students with more than 10.

Create a new query i you need to for students for <10 making sure you enter the criteria <10