I have a query that I am executing in Access that is making another table. In this table are 2 placeholder columns that would later have a date time value added to them. right now when I run the query, I have an alias name for each column:
When running it that way, the make table treats the columns as numbers. I tried formatting the columns in the properties window for each of the columns and I get the same result. Leaving the formatting for the columns, I also tried:
Column2:Format('12:00 AM',"Medium Time")
The formatting does not carry over to the make table and is given a TEXT data type.
What can be done to get this to work? Thanks in advance.