Date as column Heading

[Robert_DubYa]

Is their a way to use the current date or calculated date as a column heading?

 

[Duane Hookom]

I can't imagine why you would need to do this. I expect you can derive a
column name in a crosstab. The other solution would be to use code to create
the SQL of a query.

 

[Jeff Boyce]

Yes, probably... but why?! I can drive nails with my chainsaw ... but it
isn't a very good use of the tool.

If you'll describe the business need you're trying to solve by doing it this
way, folks here may be able to offer alternate approaches that make better
use of Access' features.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.