Sub totals and grand totals by date range

[Dirtguy]

Hi all need a small push in the correct direction.

I have a simple data base to track my trucks.

Date : Ticket # : Material : Supplier : Source : Pit : Tonne : Unit : Truck Co : Truck # : Customer : Contract

Nov21.001..........A.............Abc...........There.....1......20.........ton.......xxx............25............Him...........Hers

Each line below my headers is a record, all records can be found and sorted by any of the above fields

single or multiple criteria. I also have a date range find script with my 2 date input fields set to global.

My first report works well, find the data in the above layout, got to report 1 layout sort and print.

Report 1 layout consists of sub totals and grand totals, this works well in light of the fact I am only

looking for one of the above fields at one time. IE all material delivered to a contract on one day

of the week, search date and contract. The result gives me the proper grouping for a single day

threw my report one.

(search for single contract)

Date

Contract

Supplier

Material

Sub Total

Grand total

OR

(search for single date)

Date

Contract

Supplier

Material

Sub total

Contract

Supplier

Material

Sub total

Contract

Supplier

Material

Sub total

Grand total

And here is my problem with report two.

Date range and subtotals with grand totals.

With in a data range I would like to have my report to sum all material with a supplier grouping and material grouping.

Start date

End date

Contract ABC

Supplier XYZ

Material MNO

Sub total XXX

Supplier XYZ

Material GHI

Sub total XXX

Supplier 123

Material PQR

Sub total XXX

Grand total

If you have any pointers to reading material of sample reports, layouts or scripts that would be great.

Thank you in advance

Sean Kelly