Hi Guys,
Iam doing an Access project And i have poblem in calculation in a form. This calculation basically is between a form and a table. I have form called "Yearly _Amount" in which there is a field called "Total_Hours". Now i want to calculate this Total_Hours as Sum of hours (Hours is record in "Time_Sheets" table) Where three fields are equal ie., Employee_#,Fiscal_Year and Project_# in Yearly_Amount form is equal to
Employee_#,Fiscal_Year and Project_# in Time_Sheets Table.
Used Dcount() but dint work.
Iam doing an Access project And i have poblem in calculation in a form. This calculation basically is between a form and a table. I have form called "Yearly _Amount" in which there is a field called "Total_Hours". Now i want to calculate this Total_Hours as Sum of hours (Hours is record in "Time_Sheets" table) Where three fields are equal ie., Employee_#,Fiscal_Year and Project_# in Yearly_Amount form is equal to
Employee_#,Fiscal_Year and Project_# in Time_Sheets Table.
Used Dcount() but dint work.
