Truncating data from query for report

O

OMS

Hi,

Hope this is the right forum.

I have a report that returns the FULL_NAME (example Doe, John) from a query.

I would like to have the results look like (Doe, J.) minus brackets of
course.

I thought writing an expression would do it but don't know how. I can do it
in Excel but not sure how to apply that knowledge to Access. And yes, I do
know how to open expression builder just don't know the formula. Hope that
makes some sense.

Access 2000

Thanks in advance.

Sean
 
D

Duane Hookom

If you ALWAYS want to trim the text at the first character following the ",
" then try an expression like:
=Left([FULL_NAME], Instr([FULL_NAME], ", ") + 2) & "."
 
O

OMS

Duane,

Perfect.
I'm sure once I've done what they've asked for they'll want it changed. ;-)
Thank you sooo much.

Sean


Duane Hookom said:
If you ALWAYS want to trim the text at the first character following the
", " then try an expression like:
=Left([FULL_NAME], Instr([FULL_NAME], ", ") + 2) & "."
--
Duane Hookom
MS Access MVP

OMS said:
Hi,

Hope this is the right forum.

I have a report that returns the FULL_NAME (example Doe, John) from a
query.

I would like to have the results look like (Doe, J.) minus brackets of
course.

I thought writing an expression would do it but don't know how. I can do
it in Excel but not sure how to apply that knowledge to Access. And yes,
I do know how to open expression builder just don't know the formula.
Hope that makes some sense.

Access 2000

Thanks in advance.

Sean
Click to expand...
Click to expand...
 
Top