S
Stephen Raftery
Hi all,
I have a database which plans and records assignments of various staff to
different locations.
My report is based on a crosstab query, where the column headings are
'Monday', 'Tuesday', etc, and the row headings are 'Location1', Location2',
and 'am', 'pm'.
Now sometimes an employee is assigned to the same place for all day, so I
would like a single control to straddle the AM and PM detail sections. Can
this be done?
Further to the same question, we have holidays like Christmas and so on, and
I would like to put in a little message that straddles the whole of that
column. Can that be done. I wonder whether some kind of watermark control
might do the trick, but I cannot find whether such an object exists.
Stephen
I have a database which plans and records assignments of various staff to
different locations.
My report is based on a crosstab query, where the column headings are
'Monday', 'Tuesday', etc, and the row headings are 'Location1', Location2',
and 'am', 'pm'.
Now sometimes an employee is assigned to the same place for all day, so I
would like a single control to straddle the AM and PM detail sections. Can
this be done?
Further to the same question, we have holidays like Christmas and so on, and
I would like to put in a little message that straddles the whole of that
column. Can that be done. I wonder whether some kind of watermark control
might do the trick, but I cannot find whether such an object exists.
Stephen