Ok I am pretty new to access and was given a large database to work on with a prior developer leaving the company. I have a field named: Demand Date that comes over from a linked table in text format (ex. 1152009). While working in my select query I need to convert this to a date format...