Hi Friends.
I have a table of deadlines that has fields for due date, item due, and
person owed. The due dates span 2005, 2006 and 2007.
I want to create a report that has a three columns of [due date, item
due, person owed] for 2005 on the left of the report, for 2006 in the
middle, and 2007 on the right. It turns out this isn't as simple as
sorting by year and making 3 columns, since they might run onto more
than one page. In that event, I want them to retain their left, center,
or right position on the page based on the year. (So if 2006 dealines
run onto a second column, they will be on page 2, and not in place of
2007.)
I think I need three sets of unbound text boxes, one for each year in
the appropriate part of the report, with expressions in the control
source selecting the data for the appropriate year. I just don't know
how to write the expression. Or, maybe it can be done a better way.
Any ideas?
THANKS!
-jenn