Dynamic Report Headers

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!
 
D

Duane Hookom

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

Formatting Rows / Columns of a Report 4
Report Headers/Design 4
Excel Help with dates 2
Two Column Report , Headers not spanning width 1
CrossTab report Access 2003 1
Using Dates As Column Headings 14
Subreport headers not on main report!!! 1
Report Title 4

Top