how to make a view with date and sum calculation

[Cpreston]

Hi

I am trying to create a view which is taken from an orderheader table. The 2 fields I ma using are called daterequired and totalvolume.

I want to try and create a view that looks at todays date and the next five working days with a sum of the totalvolume against each day shown. The daterequired field is also a datetime field which is also causing headaches.

I am really stuck on how to do this, as anyone any ideas please.

Thanks

PS. Fairly new to creating Views form scratch