Dynamic Report Headers

  • Thread starter Thread starter mmmbl
  • Start date Start date
M

mmmbl

I have a report that is based on a start date and end date. The data is
totaled using the dates as column headers. Is there a way to use the column
headers on a report dynamically? For example if i choose 7/13 and 7/20 as the
start and end dates these will be column headers on the report, if I use 7/21
and 7/30 as the dates these will the column headers. The column headers dates
changes with the selected dates. Any suggestions is greatly appreaciated!
 
You can use text boxes as the report column headings. Set the control sources
to something like:
=Forms!frmDates!txtStart
=Forms!frmDates!txtStart + 1
=Forms!frmDates!txtStart + 2
 
Back
Top