find students with GPA 3.0 and above

[primobolan]

Hello everyone, i have created a table that contains student name, last name address and GPA. THe instructor asked :You must find all the students that have a GPA of 3.0 or greater. Sort them so the highest GPA is the first student in the query. i need instructions if possible , thanks...

[June7]

Use Access query builder. The resulting sql will look like:

SELECT * FROM table WHERE GPA>=3 ORDER BY GPA DESC;

This is EXTREMELY basic Access functionality and should have been covered early in lecture and text. Access Help has guidelines on using the query builder to filter and sort records.