Recent content by TBFL

Thanks very much Pat. That all makes sense. I really appreciate you taking the time to explain it.

Pat , Thanks very much for your response. I appreciate the advice, and will probably go ahead with the method using the temp tables, but want to understand the issue better. Does DSum() run a separate query for each row in the update table? (as opposed to the table being summed)? I have about...

I am relatively new to Access programming and this is my first post, so please excuse any rookie mistakes. I am trying to calculate rolling total activity within a user specified date range for each of several pieces of equipment. I have a table "MonthlyActivity" listing equipment ID...