Display Name data the other way round!

[clare_voiant]

Hi,

I have a database where the names in the Name field are displayed 'Surname Firstname'. Is there a way to display the field in the report as 'Firstname Sirname' using code?

thanks

Clare

 

[Andrew Fergus]

Hi Clare,
Is there anything like a comma separating the surname and first name? Or is there just a space?
Andrew

 

[clare_voiant]

just a space im afraid.....

 

[Andrew Fergus]

Hi Clare,

If you create a query, add the name field (or whatever you have called it) and in a new column in the "field" section enter this :

= Right ([name], Len([name]) - InStr([name]," ")) & " " & Left([name], InStr([name]," ") -1)

Remembering to use your variable name - I just used "name"

View the query and see if this is what you want. You can then use this query to either make a new table or to update the "name" field. Please beware that this query will give some odd looking results if there is more than one space.

HTH, Andrew.

 

[Andrew Fergus]

***I must read your post correctly***

You can use the logic I outlined above in the field on your report too - provided the field "name" (or whatever you have called it) is available in the underlying query or table.

A.

 

[clare_voiant]

thanks Andrew, will give it a go.

Clare

 

[clare_voiant]

Brilliant! it works wonderfully