You can use this SQL statement to sort out all the students with 5 or more
SELECT tblStudents.ID, tblStudents.Name, Sum(tblStudents.certificates) as
WHERE tblStudents.Year=2001 AND tblStudents.Certificates >= 5
GROUP BY tblStudents.ID, tblStudents.Name
The statement was written on the fly and I havent tested it, but I think you
can use some of the elements in it.
You can then export the recordset to csv or xls or xlm and then store them,
print them.... You can also display your recordset in a report in VB and
then print them out.
Check out www.planet-source-code.com to find code. ADO and export to csv,
I was wondering what would be the best way to add up records that have
information and then save (temp) them somewhere (recordset).
e.g. Database of students that have received one or more certificates from
school. I want to determine how many and which students have received more
5 certificates this year. Each student has a unique student ID and this
information needs to be stored somewhere and be printed when needed.
What do I do?