print single record in all groups in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to print a single record in every group in a report? I have a task database that stores tasks to be done on a specific day of the week or daily. I would like to enter the daily tasks only once, but have them print in each day grouping on the report. Any suggestions on how to structure the report or table(s) to accomplish this report? Thank You.
 
Simplest approach might be to use a subreport to print the every-day tasks.

Assuming you have a table (or query) that contains the tasks to be done
every day, you could put this in a subreport in the Footer section for the
day. Make sure the subreport control has nothing in its LinkMasterFields and
LinkChildFields properties, so it does not filter to the date. The records
then appear for every record.

There are other alternatives such as a Cartesian Prodcut and UNION query to
get the values into every date, but that seems more cumbersome.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Joe Black said:
Is there a way to print a single record in every group in a report? I
Click to expand...
have a task database that stores tasks to be done on a specific day of the
week or daily. I would like to enter the daily tasks only once, but have
them print in each day grouping on the report. Any suggestions on how to
structure the report or table(s) to accomplish this report? Thank You.
 
Back
Top