Hi there,

Is there any way to specify individual columns in the datagrid so that I can do an equation? There is 3 criteria that I need before I can do the equation. The purpose is to find the average of student marks. The criteria is year, class, subject (all classes) and they exist in two different tables in the database. It would be nice to specify in the data form column to pull each value from the respective forms, but it appears that I cannot. It seems that I can only tell the column to pull specific columns from the table in the database. I was thinking of doing all of the queries and calculations in the tables (Access) and automatically updating a new table that the dataform would access. This solution seems too complicated and too much work. Is there anyone familiar with the dbGrid? How can I do all of this straight from the code?