Truncating data from query for report

  • Thread starter Thread starter OMS
  • Start date Start date
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
 
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,

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...
 
Back
Top