Want today's date in Field name

[rmarquez5]

Greetings all.

When you build a query in MS Access, you can usually rename a field name to something more meaningful, if need be. Say the column in the table is called column1, but you want it to be a column named "title" for your query, you can say:

title: column1


What I want to do is make "title" a little more dynamic by adding today's date. Something like:

now() + title: column1

But instead of a column heading of "Feb 27 title", I end up with "now() + title". Any thoughts as to how I can get this to work? Is it even possible in Access??

Any input would be much appreciated. Thanks in advance. I hope to hear from you!

Richard

 

[Pat Hartman]

You would have to create the entire query in VBA. SQL doesn't have the ability to parse variable column names.