Forums
This topic is locked
Splitting a value:
Posted 13 May 2003 14:13:50
1
has voted
13 May 2003 14:13:50 Ian Etherington posted:
ok, i have a DB with 2 fileds in it, one for Surname, and one for Forename.the problem I have is how can I return just surname and the first Initial of the forename field, without adding a new field in the DB.
Thanks,
Ian
"To start press any key", where's the any key?
Replies
Replied 13 May 2003 14:38:37
13 May 2003 14:38:37 Jonathan Danylko replied:
newName = rsTable("Surname"
& Left(rsTable("Forename",1)
Hope this helps...
L8R,
Vitoman, M CIW D, MMCP
& Left(rsTable("Forename",1)Hope this helps...
L8R,
Vitoman, M CIW D, MMCP
Replied 13 May 2003 14:53:27
13 May 2003 14:53:27 Ian Etherington replied:
thanks alot
sorted!
Ian
"To start press any key", where's the any key?
sorted!
Ian
"To start press any key", where's the any key?