Hello to all,
Msaccess 2003
I want to extract anything after the SLASH (CustNo) and update
another field (OrderDate) in the same table.
I am looking for a function to do this because my table is big.
Any help would be appreciated
thanks a bunch
TableA
Before
===========
CustNo (text)
2343/98A
4654/91B
5674/89W
3673/00W
6788/02C
5775/05D
7895/0D
After (OrderDate)
==============
1998 or 1/1/1998
1991 or 1/1/1991
1989 or 1/1/1989
2002 or 1/1/2002
2000 or 1/1/2000
2005 or 1/1/2005
2000 or 1/1/2000
Msaccess 2003
I want to extract anything after the SLASH (CustNo) and update
another field (OrderDate) in the same table.
I am looking for a function to do this because my table is big.
Any help would be appreciated
thanks a bunch
TableA
Before
===========
CustNo (text)
2343/98A
4654/91B
5674/89W
3673/00W
6788/02C
5775/05D
7895/0D
After (OrderDate)
==============
1998 or 1/1/1998
1991 or 1/1/1991
1989 or 1/1/1989
2002 or 1/1/2002
2000 or 1/1/2000
2005 or 1/1/2005
2000 or 1/1/2000