Names

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / General 2 / January 2008

Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chi - 23 Jan 2008 01:53 GMT

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

Reply to this Message

fredg - 23 Jan 2008 02:02 GMT

> Hi,
>
[quoted text clipped - 5 lines]
> Thanks
> Chi

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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2009 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.