Hi HTH,
With help of this forum, I have created my Document Tracking Database for my project use. Now everything is working fine except the Progress Calculation. I would like to do the progress calculcation in Access.
Progress calculation can be performed with Sumproduct function. Could you please help me to understand how we can perform Sumproduct in Access since there is no built in funtion for the same.
I would like to display the results in a form, when I click the calculate button.
I understood that We can use excel function in access by Application.Worksheet function however I don't know how to get the Query field names in the same.
Herewith I had enclosed my Database for your review.
My Formula will be like this
Sumproduct ([MHRS NEW INT],[InternalProgress])/sum(([MHRS NEW INT])
Thanks and Regards
R. Vadivelan