Part Display

[Crampton]

Hi everyone.

Not quite sure how to go about this but here's the problem:-

I have to produce a report showing only the initials of a person's surname, and just the first 4 digits of a person's postcode.

The 1000s of records which are currently in the database at the moment are as follows:- Colin Smith, James Brown etc etc

I would like this to display C S, and J B on the report.

The same goes for postcoding, ie:- ME2 3ER

I would like this to display ME2 3 on the report.

Can anyone help me with this please.

Thanks all.

 

[FoFa]

If the postal code is always xxx xxx you can use LEFT(PostalCode,5). Names are an issue if they are contained in one field. You can parse them looking for space, but you usually run into those that are suppose to have a space and then they get screwed up. If the names are in different fields, you can use LEFT(FirstName,1) & " " & LEFT(LastName,1) (using your example).

 

[Crampton]

Thanks FoFa for that help is seems to be the answer .

Thanks again