Does anyone know how to sum fields in ms access using SQL and then place it in datagridview? I have a ms access table with fields 'Points' and 'FacultyID'. I would like to know how to sum all values on 'Points' field and place it in datagridview. Also, I would like to know how to filter values from 'Points' based on selected 'FacultyID'.

Thanks :idea:

The best way is to create the queries/views in access and test them.

Then use the access queries/views as a data table in a data set, and fill them using a data adapter with 'SELECT * FROM MyAccessQuesryOrView'

Hope this help