Substitute calculation

[topaznz]

Hi there Forum

My question surrounds the Substitute formula used to display name full name of patients in a medical database.

Patient records were filed in "Title First name Middle name Last name" format. Now the clinic wants them filed as "LAST NAME, First name Middle Name" format.

How do I get the "Last name" to appear in capitals and a comma directly after to separate from First name.

Substitute ( List ( Last name ; First name ; Middle name ) ; ¶ ; " " )

The system in question was born with the generous help from these forums and it is wonderful to be able to revisit during redevelopment!

Kind regards

Tim

[David Jondreau]

Upper(Last Name) & ", " & First Name

[topaznz]

Perfect, works great. Thanks for your reply D J!