Names

  • Thread starter Thread starter Chi
  • Start date Start date
C

Chi

Hi,

In the Provider field, the provider names entered as HELFRICH, SHEILA. I
would like to make it appears in the report as Sheila Helfrich. Please help.

Ex: HELFRICH, SHEILA to Sheila Helfrich

Thanks
Chi
 
Hi,

In the Provider field, the provider names entered as HELFRICH, SHEILA. I
would like to make it appears in the report as Sheila Helfrich. Please help.

Ex: HELFRICH, SHEILA to Sheila Helfrich

Thanks
Chi
Click to expand...

In an unbound control on your form or report:
=Mid([Provider],InStr([Provider],",")+2) & " " &
Left([Provider],InStr([Provider],",") -1)
 

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

Setvalue action not available in Macro? 2
Lookup formula of some sort 4
Replace text from a specific character 2
Anyone know what .RPD files are.... 17
Database splitter, where are my objects.... 3
Include Table name in Query result? 4
Can I use the same form for multiple reports 10
Why does the sort order change... 1

Back
Top