G
Guest
I have a make table query that I run daily. One of the fields of the query
is a date field. The source table for the query treats the information as a
text string in a date format that is not recognized by access. I have
created formula that parses the string to put it into standard "mm/dd/yy"
format. However, when I run the make table query it treats the date field as
text. This is a problem because I use a form to hold the criteria for a
query that I run on the new table. In order to get the query to work, I have
to manually set the data type to short date. This will not work at the user
level, because most of them have no clue how to set a data type. Is there
anyway to force access to recognize my date field as a short date data type?
Thanks in advance for the help.
is a date field. The source table for the query treats the information as a
text string in a date format that is not recognized by access. I have
created formula that parses the string to put it into standard "mm/dd/yy"
format. However, when I run the make table query it treats the date field as
text. This is a problem because I use a form to hold the criteria for a
query that I run on the new table. In order to get the query to work, I have
to manually set the data type to short date. This will not work at the user
level, because most of them have no clue how to set a data type. Is there
anyway to force access to recognize my date field as a short date data type?
Thanks in advance for the help.