Cumulative Monthly Returns

[tcread]

OBJECTIVE
I'd like to be able to query the cumulative monthly returns of a given
stock based on the daily returns. I need to do this for 1000
securities over 5 years (60 months)

TABLES
Returns ~ with the following fields:
1. ID
2. Ticker
3. From (prior date end)
4. To (current date end)
5. Return

Trade Days ~ with the following fields:
1. ID
2. From (prior date end)
3. To (current date end)
4. Month (number for month)
5. Year (number for year)

PROBLEM
I need to calculate the returns on a monthly basis. Therefore I need
the following calculation(s):
1. first day of the = returns for that day
2. second day = (1+prior day)*(1+current day return)-1
3. get end of month value

I'm a VB rookie, and have not been able to recreate basic excel
calculations for the life of me.

Thanks so much for your help!