Search results

I have two tables, tblAcct first has 3 fields: AccountID, StartDate, EndDate The second, tblData, has the 2 fields: DDate, iValue I need a query that will sum iValue over the Start and End dates in each record in tblAccount, For example: tblAcct: AccountID StartDate EndDate CDD001...