>
>Wonderful Kevin, thank you very much, this will help me to improve the code you gave me before. Sorry I didn't reply yesterday I got disconnected before you. Right now what I'm dealing with is this:
>I was asked to return 2 grids, first one grouped by days in the number of days end user specifies and the second grid the whole data from date start to date end grouped by week. In example, the end user wants quotes from 09/01/2015 to 09/22/2015, first grid with the last 10 days (He wants that parameter). So what the page must display is a first grid grouped by day and showing data from 09/13/2015 to 09/22/2015. Then display a second grid grouped by week and showing data from 09/01/2015 to 09/22/2015. What do you think?
OK, so the 2nd grid doesn't need a grand total....it just needs totals summarized by week?
Also, is your week based on Sunday to Saturday?
Thanks