Return (display) only part of a field

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
 
A

Allen Browne

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.
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
Return records based on calculated field 11
Return only the numbers contained in a field 6
disctinct query memo field 3
Append only part of field record 3
Macro - add 2 spaces after the end of a sentence. 0
display part of a field 1
Remove part of field 2

Top