Lonnie Johnson
prodevmg at yahoo.com
Wed Jan 5 06:51:53 CST 2005
Have you tried setting the format of the column in the design grid of the query to "Short Date" or "mm/dd/yy" ? Terri Jarus <jarus at amerinet-gpo.com> wrote: I am linked to a table of data from our AS400/DB2 system and a date field appears as 20050105. I need Access to read this as a date - what is the best way to handle/convert this field. I've tried breaking it apart and putting it back together in a query as 01-05-2005 but Access does not recognize as a date field. I want to query out data based on a date - please advise. Thanks for your help. Terri Jarus Vice President, Contract Services jarus at amerinet-gpo.com 314-542-1902 --------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individuals or entities to whom they are addressed. If you have received this email in error please return it to the sender, and erase any copies thereof. Copyright 2004 Amerinet 1nc. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? All your favorites on one personal page – Try My Yahoo!