Report with Changing Field Names

[TheSearcher]

Hello,
I have an application in which the user can select a range of up to seven dates. My code produces a table in which each of the dates appear as column names. Obviously, the names will change as the users choose different dates. How can I create a report that keeps the dates as column names if the names will be unpredictable?

This is an example:
Employee, 11/18/2013, 11/19/2013, 11/20/2013, 11/21/2013

Thanks in Advance,
TS

 

[Geotch]

I would change your table to use fields like date1, date2, .... date7. Add seven more fields called date1 date, date 2 date.... date 7 date. Date1 date = 11/18/2013 from your example above.

Hope that helps.

 

[TheSearcher]

Hi Geotch,
Thanks for responding - but I don't think I understand what you mean. Can you elaborate a bit more? How can I get the dates to be field names? Sorry for not understanding.
TS

 

[Geotch]

I created an example but with only four date fields. Look at the data in the table then look at the report.

Instead of changing the table fields, update date1, date2, date3, etc. Then put your date in date1date, date2date, etc.

I put the dates as a report header so they aren't labels.

 

[TheSearcher]

Geotch,
Your sample database was exactly what I needed. Very clever. Thank you very much for taking the time to work on this!
Regards,
TS

 

[Geotch]

Thanks, have had the same issues myself.

 

[TheSearcher]

Hello again,
One more question: For some reason, my report previews as one page. It should probably be about 100 pages. It's just one, very long, page. Why would this be happening?
Thanks,
TS

 

[Geotch]

You know it access you have to scroll through each page.
There's record selectors the bottom left of the screen

 

[TheSearcher]

That's the problem. The record selectors are not there. If I scroll all the way to the bottom (and it's a long way) it just says "Page 1."

 

[TheSearcher]

Nevermind. I weas looking at "Report View." Sorry to bother you.