Search results

Hi, I have no idea, that's why I posted in the forum. I tried different options but could never get the answer I wanted. I have never used DSum before and can't quite get my head around the proper syntax. My data has approx 45000 rows and previously I was calculating a running total in Excel...

Not sure but it works. I added a Index column to my data and included that in the code so that it didn't recalculate after the end of a period. Thanks to arnelgp for the help.

Thanks, works perfectly.

Thanks but it still calculates to 60?

Hi, I have a table (Table is called "Item Data")where I am trying to calculate a running total per Item. This is my expression: DSum([Quantity Purchased],"Item Data","[ItemID]=" & [ItemID]) Trouble is it's not calculating it correctly as you can see in the screen shot. ItemID 1775 should...