cepes
asked on
Access 2003: Convert date into text
Hi:
I have a field called [ShortDate] which reads a year and month as: "2006 06" for 2006 June. I would like to make another field from this one that reads: "2006 June". I imagine that an amendment to the following query would be easiest.
SELECT tblTFILE_New_TFILE_DateA60 504_Conver ted.KEY, tblTFILE_New_TFILE_DateA60 504_Conver ted.DEPT, tblTFILE_New_TFILE_DateA60 504_Conver ted.REC, tblTFILE_New_TFILE_DateA60 504_Conver ted.NAME, tblTFILE_New_TFILE_DateA60 504_Conver ted.CODE, tblTFILE_New_TFILE_DateA60 504_Conver ted.FDATE_ Converted, tblTFILE_New_TFILE_DateA60 504_Conver ted.FDATE, tblTFILE_New_TFILE_DateA60 504_Conver ted.DESC, tblTFILE_New_TFILE_DateA60 504_Conver ted.OP_ID, tblTFILE_New_TFILE_DateA60 504_Conver ted.ShortD ate INTO tblTeam3APPOsByOperator
FROM tblTFILE_New_TFILE_DateA60 504_Conver ted
WHERE (((tblTFILE_New_TFILE_Date A60504_Con verted.OP_ ID) Like "RM" Or (tblTFILE_New_TFILE_DateA6 0504_Conve rted.OP_ID ) Like "CD" Or (tblTFILE_New_TFILE_DateA6 0504_Conve rted.OP_ID ) Like "NC"));
Thanks!
Charlie
I have a field called [ShortDate] which reads a year and month as: "2006 06" for 2006 June. I would like to make another field from this one that reads: "2006 June". I imagine that an amendment to the following query would be easiest.
SELECT tblTFILE_New_TFILE_DateA60
FROM tblTFILE_New_TFILE_DateA60
WHERE (((tblTFILE_New_TFILE_Date
Thanks!
Charlie
which field is it u want
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
[ShortDate]
ASKER
Sorry... just thought of another issue... If I change to "2006 June" formatting, I lose the sort sequence order of having 2006 06... I suppose I could sort by ShortDate and make it not visible in the report...
Charlie
Charlie
That would be the best way to go... simpler than working out a sort on 2006 June etc.
Format([datefld],"YYYY MMMM")