G
Guest
I need some solution to this.
I have a MakeTableQuery date converts a text field to date:
Format(CDate(mydatefield), "dd-mm-yyyy")
This MakeTableQuery adds a new column for the conversion text to date,
althought, this new column mantains a text type. When I try to change the
data type tp Date Access returns an memory error. Maybe because my table has
more than 400.000 records.
Is there any way to convert the field to have the data type changed to Date?
I have a MakeTableQuery date converts a text field to date:
Format(CDate(mydatefield), "dd-mm-yyyy")
This MakeTableQuery adds a new column for the conversion text to date,
althought, this new column mantains a text type. When I try to change the
data type tp Date Access returns an memory error. Maybe because my table has
more than 400.000 records.
Is there any way to convert the field to have the data type changed to Date?