Return days in month as rows

[JohnandSwifty]

Hi,

I want to return a list of the days in a chosen month (1 day per line) and then show summarys for the day on the row - e.g.

1st £256.23 56
2nd £526.31 98
3rd £485.25 12

will i need to create 31 queries ? or is there a better way?

thanks!

 

[TruthInSatire]

There is a better way. Run the query to capture the month you need. sql has a month function or you could use CF to get the last day of the month and use between, there are a few ways to do it. Then output like a regular query. You may need to do some checking to fill in empty days if you have any.

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.