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

Thank you LaRetta, 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

Hi all, not sure if I am in the correct forum or not to ask a few questions about building a report. Can someone point me to the correct sub, thank you. Sean