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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print a date range from parameter query on a report header? 2
Parameter Query In Report Title 3
Excel Help with dates 2
Formatting Rows / Columns of a Report 4
Show Parameter Information in Report Footer 1
Report Header Information - Alberta Rose 6
Report Headers/Design 4
Variable # of Column Headings in Crosstab Report 2

Back
Top