Search results

I just tried it on my real db, it works great. Thanks!

I posted the file before I saw your response. Attached is the zip version.

I attached my file. I didn't see the upload link before because I was in the quick reply screen.

Sure. I don't see a link or an icon on the forum that will let me upload my file. How do I do it?

I was hoping I could use a subquery or dsum, but I don't know how.

I took a look at your link to Total Queries, I don't see how that will do what I want.

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...