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

How do I freeze the swimlane headers? 0
Creating a Search using a combo box and then creating a report. 4
(headers & footers Issue) I have 2 even pages back to back!! 1
Formatting Rows / Columns of a Report 4
Countdown macro - display settings 2
Report Headers/Design 4
Cannot sort a table containing text 5
Loop through pages and insert header image 0

Top