Truncate Text

[js22]

Hello,

I'm working on a database that manages plant specimens. I have this calculation in my database

Lookup ( PCRSamples::Sample Genus ) & " " & Lookup ( PCRSamples::Sample Species ) & " " & Lookup ( PCRSamples::Sample Sub Species )

This field combines all of the taxonomy into one calculation. However, when I enter the data I use the full name of the Genus and Species. What I want to do is truncate the first two lookups to two letters:

Ex: Pteridium Aquilinum Japonicum turns into Pt. Aq. Japonicum

Does anyone have any ideas on how to do this.

Thanks

js22

[Raybaudi]

Left ( Lookup ( PCRSamples::Sample Genus ) ; 2 ) & ". " & Left ( Lookup ( PCRSamples::Sample Species ) ; 2 ) & ". " & Lookup ( PCRSamples::Sample Sub Species )

[js22]

Thanks,

It does exactly what I want it to do.