By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

Renaming a field in msaccess query

P: 3
I have field called Datoutkd in my table, I need this field to rename date in the query. I used the replace function in order to create a new column with date as the field but could not work.
Please your advice is needed to solve this problem
Aug 23 '08 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Your objective "I need this field to rename date in the query" isn't clear to me.
When you need just the name "Date" (or safer "DateOutput") in your qery result just use:
Expand|Select|Wrap|Line Numbers
  1. select Datoutkd as DateOutput from tblX
  2.  
When you want to change the datatype from text to date, then define an additional column with datatype Date and update that with the statement:
Expand|Select|Wrap|Line Numbers
  1. update tblX set DateOutput = Cdate(Datoutkd)
  2.  
Nic;o)
Aug 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.