Return (display) only part of a field

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brett" wrote in message
...
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

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

"Brett" wrote in message
...
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