I have dates on two tables and I want to get the sum of a different number on each table. I have a task table with a date on it and a field that has the duration of the time expected to complete the task in interger format. I have another table that pulls in my google calendar. It has dates on it and a field with a duration on it in interger format. I want create a grid that gives me the next two weeks day by date and the sum of those two duration fields. Is this possible? What is the easiest way to do it?
