Search results

That works!! Thanks for your help.

Removing the double quotes gets a syntax error: Running_Total: DSum(" [Topic_Duration] ","QRY_TOPIC_COMBO","[Topic Order]<" & [Topic Order] & And "[Meeting_id]=" & [meeting_id] & ) I'm not sure what the correct format is -- how would you format this to get it work?

Running_Total: DSum(" [Topic_Duration] ","QRY_TOPIC_COMBO","[Topic Order]<" & [Topic Order] & "" And "[Meeting_id]=" & [meeting_id] & "") returns 195 for each record -- the sum of the field

The quotes were copied from other examples I've seen for dsum. I have tried different variations of quotes but that doesn't seem to be the issue.

I'm not sure I understand. I swapped my criteria for yours and got the same result -- am I missing something?

Plog, Thanks -- I change the quotes to match your suggestion but I get the same results.

I have a query with the following fields: Topic Duration Topic_Order Meeting_ID Data source: qry_topic_combo Topic_Duration Topic_Order Meeting_ID 15 1 7 45 2 7 15 3 7 30 4 7 15 1 8 30 2 8 30 3 8 15 4 8 I am trying to generate a running total of topic duration by topic_order and meeting ID for...