Hello everyone,
I need to create a report based on a daily log that is to be generated each week. At the top of the report I want the headers Monday, Tuesday, Wednesday, Thursday, and Friday and below those days of the week headers/labels I want the date of Monday, Tuesday, etc. The days of the week will always be the same so I know to use labels but how do I get the dates to correspond every time I run the report? Also, if no business was done on Monday, for example, because it was a holiday, how do I show that on the report? I want the user who creates the report to enter in Monday's date and Friday's date and come up with a report that shows Monday - Friday and the breakdown of each date. Any help/ideas/notions/etc?
I need to create a report based on a daily log that is to be generated each week. At the top of the report I want the headers Monday, Tuesday, Wednesday, Thursday, and Friday and below those days of the week headers/labels I want the date of Monday, Tuesday, etc. The days of the week will always be the same so I know to use labels but how do I get the dates to correspond every time I run the report? Also, if no business was done on Monday, for example, because it was a holiday, how do I show that on the report? I want the user who creates the report to enter in Monday's date and Friday's date and come up with a report that shows Monday - Friday and the breakdown of each date. Any help/ideas/notions/etc?
