Changing Field Properties using queries

[stag246]

I have a table which i am running a query from which is linked by ODBC. there
are many fields in the table. I am pulling 6 of them out of this table using
a query. Id, totime, fromtime, empID, earncode, distcode. The totime and
fromtime are both have text properties. Is there a way to use a query to
change those to a time/date property and put them in a table I would create
locally to this DB?

Thanks

Jeremy

 

[Ted Allen]

Hi Jeremy,

If you just want to coerce the value to a different data type on your end
(and not modify the ODBC connected table itself), you should be able to use
the CDate() function to return a date data type rather than text. Just enter:

CDate([YourFieldName])

as the field value in the query.

HTH, Ted Allen

 

[stag246]

thanks ted that did the trick

Hi Jeremy,

If you just want to coerce the value to a different data type on your end
(and not modify the ODBC connected table itself), you should be able to use
the CDate() function to return a date data type rather than text. Just enter:

CDate([YourFieldName])

as the field value in the query.

HTH, Ted Allen

I have a table which i am running a query from which is linked by ODBC. there
are many fields in the table. I am pulling 6 of them out of this table using
a query. Id, totime, fromtime, empID, earncode, distcode. The totime and
fromtime are both have text properties. Is there a way to use a query to
change those to a time/date property and put them in a table I would create
locally to this DB?

Thanks

Jeremy

 

[Ted Allen]

My pleasure, glad it helped.

thanks ted that did the trick

Hi Jeremy,

If you just want to coerce the value to a different data type on your end
(and not modify the ODBC connected table itself), you should be able to use
the CDate() function to return a date data type rather than text. Just enter:

CDate([YourFieldName])

as the field value in the query.

HTH, Ted Allen

I have a table which i am running a query from which is linked by ODBC. there
are many fields in the table. I am pulling 6 of them out of this table using
a query. Id, totime, fromtime, empID, earncode, distcode. The totime and
fromtime are both have text properties. Is there a way to use a query to
change those to a time/date property and put them in a table I would create
locally to this DB?

Thanks

Jeremy