Names

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
 
F

fredg

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)
 
Top