I cannot get the syntax right in the RunningSum expression in my query. See attachment.

[Greek]

Would someone kindly help me get the dsum syntax in the running sum expression. See attachment please.

[orange]

A few questions/observations:

Each Order in your system has only 1 Product, is that correct?
You will encounter syntax errors with embedded spaces in your field names.
Order should be linked to Customer on CustomerID not CustomerName.
Product should be linked to Order on ProductID, not ProductName

You seem to be missing an OrderDetail table.

The most common set up for tables where a Customer makes one or more Orders fro one or more Products is as follows:

Customer-->Order--->OrderDetail<--Product

I recommend you research Normalization and database design before jumping too deeply into Access.

See this link (post #3) for more info.

Good luck.

[CJ_London]

once you have those resolved, with reference to your dsum, you refer to a total field in the tblOrder table - there isn't one. And I think you need to be using orderdate in the criteria part. You also appear to have two sub total fields, one in the query and one in the table

[Greek]

Thanks very much.

[Greek]

Thanks, Ajax