Please.. some one help me in building this expression in the forms

[reddy]

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 a 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) Whenthree 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.

Please guys help me out. Iam struggling too hard but iam not finding a solution.

 

[Mile-O]

I am struggling too hard but iam not finding a solution.

If you want help then you are best not to waste peoples' time by posting the same question in different places. You already have a thread open for this problem - you don't need another one.

http://www.access-programmers.co.uk/forums/showthread.php?t=85290