|
Subject:
|
get only a piece of the value of the column
|
|
Posted By:
|
giulio_santorini
|
Post Date:
|
9/18/2003 8:15:17 AM
|
Hi,
when I make a select I would like to take just the characters from a point until the end, is this possible in Access?
Thanks!
|
|
Reply By:
|
BethMoffitt
|
Reply Date:
|
9/18/2003 9:04:05 AM
|
Yes it is. But what is your identifier?
This is an example where it looks for the first space and takes everything to the right of the space which is identified by " ":
Right([NameofField],Len([NameofField])-InStr(1,[NameofField]," "))
HTH,
Beth Moffitt
|
