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?
Bookmarks