How do you create a SQL Select statement to read a field with a data type of text and a field value of 20110426 so that the result set is displayed as 04/26/2011?
Posted on 2011-04-29
I am working with Access 2003 using an MDB type file.
I want to SELECT fields from 2 tables and save these values into another table.
I SELECT from a table titled IMNYCashBreaks and a field titled "ValueDate" with a field type of TEXT and the value is 20110426.
I stored the SELECT results into a table titled tblOpenItems and a field titled "processdate"
with a field type of Text and the value should be stored as 04/26/2011.
I want to retain the field as a TEXT field because I am adding records to an existing table.
Do you know how to revise the following SELECT statement so that it converts a value of
20110426 for the field ValueDate into a converted value of 04/26/2011 as a text field?
FROM tblBanksConv AS b, IMNYCashBreaks AS a
WHERE left(a.BalancePool,3) & mid(a.BalancePool,5)=b.[GLAcct#];