Subtotal value by chnage in date

[chally3]

Good afternoon all,

Can anyone help please, I am really stuck and have been searching online to no avail for an answer.
I have a table of data(sales orders due ) exported into an access table and all i want to do is subtotal the value at a change of date, so we can see the days potential output. It sounds so easy,but I'm really stuck. piece of cake in excel, but this reports pulls across several databases.

The related columns are DUE DATE and LINE VALUE I'd just like to see the days total value as a subtotal


Thank you

 

[sheetspread]

Use a summary query (SQL DISTINCTROW) to view the totals in the query, or in the report you can sum at each group. All of this can be done through the wizard without writing any code.

 

[chally3]

Use a summary query (SQL DISTINCTROW) to view the totals in the query, or in the report you can sum at each group. All of this can be done through the wizard without writing any code.

Perfect, and so simple! Thank you