Update Query

Joined
Apr 2, 2006
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top