Struggling to upload, but I will try again when I get home from work.
I have tried this statement.
Runtot: (Select Sum([Qty]) from [QCombinedInventory] as a where a.[Timestamp]<=[QCombinedInventory].[Timestamp])
I get numbers, so a sense of achievement has been reached, it is just they are all...