hi all,
I have a problem which i am finding hard to explain but here goes. a customer wants to get a report automatically generated from a web page and emailed to them, this report has to be an excel sheet. so far so good, i use a simple select statement and copy to type excel, pass in the name of the file to an email dll that i have and everyone is happy. BUT this report now has to be expanded. what they need is for the report to take all transactions with a required by date either today or in the future and then group them by week, which starts on a monday. so if the report is run on a wednesday i have to group the next few days into one week, total that, then get the next 7 day starting from the following monday and total that and so on. this can go as far forward as a year but many weeks would be empty. is there a neat way to do this?
Slán
~M