Function as Field Name in Access

I have a query that I would like to put a function as a fieldname such as

select start_Date as Date() from table

The problem is access does not ssem to allow functions to replace field names. Is there a way of getting around this?
LVL 2
sesurbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JCinDECommented:
Okay I need clarification:

Do you want to have a field named 'start_Date' that contains today's date?

  select Date() as start_Date from table

Do you want to have a field named 'Date' that contains the value in start_date?

  select start_Date as [Date] from table

Do you want to have a field named 'Date()' that contains the value in start_date?

  select start_Date as [Date()] from table
0
JCinDECommented:
Above, I use [ and ] to enclose a field name that Access normally recognizes as a special keyword. The [ and ] force Access to treat it as a field name.
0
sesurbAuthor Commented:
The solution
select start_Date as [Date()] from table
is what I want but when I do this Access outputs the fiels as a string "date()" when I actually want it to be "10/22/2003" or whatever the current date is.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

JCinDECommented:
Okay so what you want is my first suggestion. A field named 'start_Date' containing the day's date:

  select Date() as start_Date from table

0
JCinDECommented:
What is in the field named 'start_Date'?

If what's in there is a string that you want to convert to a date, do this:

  select CDate(start_Date) as start_Date from table
0
sesurbAuthor Commented:
The field contains non-pertinent information. What is happening is that records are categorized by month and the data is already there but we need to change some column names to there corresponding month but that month changes depending on the data so if I can just get an actual dynamic date as the column header then I can manipulate to meet my needs but I am having trouble getting the date as the column header.
0
sesurbAuthor Commented:
And it is the last slection that I need not the first.

 select start_Date as [Date()] from table
0
JCinDECommented:
oh, you want today's date as the column header?

Well you can try doing a crosstab query with MonthName(Month([start_Date]),False) as a Column Heading

But otherwise, I don't know of any way to dynamically change the column heading names within a query.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sesurbAuthor Commented:
I think the crosstab query might work or at least the basic concept of the crosstab query. I will let you know the outcome
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.