Return (display) only part of a field

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

Hello,

How would I go about in SQL - Access to display only part of a field
after a specific character?

For example,

In Invoice.Memo, there would be variations on the following:

"SO 3453. Serial # 243"

Basically, I would like to see any data in the memo field AFTER the
period (and this field would only have one period) returned in the
query (not the stuff before it).

Invoice.Memo Returns:
Serial #243

Thanks in advance,
Brett
 
In query design view, type an expression like this into the Field row:
Mid([f], Instr([f], ".")+1)

Substitute the name of your memo field for f.
 
Take a look at the Mid() and InStr() functions in Access.

Use these to grab off everything after the "." in a query field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top