Member Avatar for eiallen

hi,

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:

  • 2 Contributors
  • 1 Reply
  • 106 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by lolafuertes
Member Avatar for lolafuertes

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.