Hello
I need help with this formula. I have the following table
Provider Name Year Month Charges Payments
John 2009 January 14,300 11,000
John 2009 February 24,000 10,700
Smith 2009 January 7,000 3,00
Smith 2009 February 15,000 8,000
The following formula i have in excel. =SUM(January Payments +February Payments)/(January Charges+February Charges). How can i does this in access.
Thank you