J
Jeff Boyce
First of all, if you are "linking to a ..." data source, you cannot "change
the ... field ... to a Date type". You can only make changes to the
underlying field data type when you are working with a 'local' table.
Next, you indicate that the field is a "date field" ... does that mean that
it holds dates? If so, is there an example of data now stored in that
field? You call it "text", but ???
If you use CDate() to convert to a date/time data type, why are you then
formatting the dates?
Why not just sort the converted value?
Regards
Jeff Boyce
Microsoft Office/Access MVP
the ... field ... to a Date type". You can only make changes to the
underlying field data type when you are working with a 'local' table.
Next, you indicate that the field is a "date field" ... does that mean that
it holds dates? If so, is there an example of data now stored in that
field? You call it "text", but ???
If you use CDate() to convert to a date/time data type, why are you then
formatting the dates?
Why not just sort the converted value?
Regards
Jeff Boyce
Microsoft Office/Access MVP