Search results

I looked at the VAL function but the numbers don't appear in the same place every time. Can I use the IIF statement to delete the < then I could just use the left, 1 to read the number? Steve

: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...

Solution Hi All Thanks for the replies, below is what I used and it seems to work CMonth_Ex: Abs(Left([created at],2)) CDay_Ex: Abs(Mid([created at],4,2)) CYear_Ex: Abs(Mid([created at],7,4)) Create Date: Format(([Cday_ex] & "/" & [Cmonth_ex] & "/" & [CYear_ex]),"dd/mm/yyyy")

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...