I am working on a work-loading, scheduling report from my publishing production database. There are a number of projects on the go, each with many tasks (copy editing, proofreading, collating, checking etc). I want to create a report which shows the tasks to be done in any one week on all live projects, but which only shows those fields where the task date is current not all the other task dates for that project. I can do the find request to find all those tasks with the current dates, but this then shows all the other dates. Is there a way of making the display criteria only show the current task (a different one for each project, sometimes more than one). Or am I approaching the problem from the wrong angle?

What is a record in your file(s)? A task? A project? If it is a task, omitting the tasks you don't want to print using a find or a "go to related record" is the way to go. If a record is a project and task a buried in fields in the record, create calculate display fields which calculate to a blank when you don't want to show them. Us the "sliding/printing" options to close up the white space on the report.

-bd

Thanks. The records are projects and the tasks are some of the fields in them. I shall try your second solution.