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