Hey AWF.
I’m building a task tracking database, and I’ve hit a wall.
My main data table stores a single record for each outstanding task with a start date and an end date for each unique task.
I’m trying to produce a report that lists all tasks scheduled every day. I’m using a query that displays all records that fall within a user-defined date range, but I can’t figure out how to group my data to display each task scheduled for each day.
Ideally, the report would list all tasks scheduled for Monday and Tuesday, with each day occupying its own page. Any task scheduled for Monday only appears on the page for Monday. Any task scheduled for Monday and Tuesday would appear on BOTH pages, so the record would appear twice in the same report.
Complicating matters, I’m trying to make the report range flexible. Sometimes I need two days at a time, sometimes five.
Any suggestions?
I’m building a task tracking database, and I’ve hit a wall.
My main data table stores a single record for each outstanding task with a start date and an end date for each unique task.
I’m trying to produce a report that lists all tasks scheduled every day. I’m using a query that displays all records that fall within a user-defined date range, but I can’t figure out how to group my data to display each task scheduled for each day.
Ideally, the report would list all tasks scheduled for Monday and Tuesday, with each day occupying its own page. Any task scheduled for Monday only appears on the page for Monday. Any task scheduled for Monday and Tuesday would appear on BOTH pages, so the record would appear twice in the same report.
Complicating matters, I’m trying to make the report range flexible. Sometimes I need two days at a time, sometimes five.
Any suggestions?
Last edited: