Truncate text

  • Thread starter Thread starter noodnutt
  • Start date Start date
N

noodnutt

G'day

I know in Excel there is a way to shorten text in cells without deleting any
of the text itself, can this be done in Acc97.

eg Format([Suburb],"????")
Say for instance I have "Melbourne" displayed in a field, I only want
"Melb".

TIA

Mark.
 
noodnutt said:
I know in Excel there is a way to shorten text in cells without deleting any
of the text itself, can this be done in Acc97.

eg Format([Suburb],"????")
Say for instance I have "Melbourne" displayed in a field, I only want
"Melb".
Click to expand...

SELECT LEFT(Suburb, 4) FROM Neighbours;

Jamie.

--
 
Back
Top