sort by date with summary

[crazybake]

Alright, I have to word this correctly....

I have a list of equipment with days it is supposed to run and hours for each job that will run that day... again only as a group of unsorted records. Is there a good way to sort the list so that each day is separated and that at the end of the list for each day I can insert a summary field that would show the total hours for the jobs for each day?

thanks again.. sorry for my unclear posts!!

[jnmorrison]

Sounds like what you need is a simple sub summary report based on the date field.

Create a new sub sammary report when sorted by date, with the date field being placed in the sub summary area. All else placed in the body area. Sort the data by date then change to preview mode to view or print.

As for the summary, create a summary field which totals the hours field, and place it in the sub summary area of the report as well.

[crazybake]

Yep, that's what I need... but, I don't know how set the script correctly so that when a list has been created with various dates that these can be sorted and SEPARATED by a summary field... i.e. 50 records with due dates on various pieces of equipment are broken down by pieces of equipment and sorted by date (this I can do)... then ... how do I create a schedule for that piece of equipment for a week , for example, so that it adds a summary field for hours at after each day...