Is there a way to format a field in access query without changing the name of the original field?
Example: Field name is DATE, I want to format it with dd/mm/yy. My code in access would be Date: Format([Date],"dd/mm/yy") but it will not work as the NEW NAME is similar on my original name, I don't want to change my original field name which is DATE. Is there any solution to this?
First off, your issue may be the field name itself. DATE is a reserved Access name that should never be used as a field name. Look at information about Reserved Names.
https://support.office.com/en-ie/art...9-f855bdd9c5a2
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Apologies, my example may be incorrect. But how about Exp1: Format([DATE1],"dd/mm/yy")? My question would be, how do I name my exp1 the same as the original field name which is DATE1?
Btw, thanks for the reserved names, I didn't know that.
I don't believe you can. Once you create an expression, the SQL statement from the UI creates an alias. If the expression is the same name as the field name it creates a circular error. The expression needs to have a different name, ie. "NewDate1"
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks