Search results

:confused: Hi All I'm sure this is really simple but I'm new to Access and can't find anything simalar already in the furum, probably because it is so easy. I have a make table query that has a Colunm called Days Open as below . I want to extract the number from the field and loose everything...

Hi All I’m fairly new to Access so forgive me if this is a newbie question. Access 2003 SP2 Excel 2003 SP2 Keyboard English UK I have a software package that produces an Excel sheet with the date displayed as follows in the Created At column “02/18/2007 @ 03:53pm” the field is in text format...