Splitting a Field and a Diffferent Description

[scott1971]

Guys,

I am on CR XI. I have a list of 3 to 5 digit codes in the format 000 running to 999.99 Each of these codes has a descriptive.

I have created a formula to only show the first 3 digits of the code ie 000 to 999 so as it will 'roll' the codes together. What I also need to add is the correct descriptive but that isn't happening. I think it's getting the first descriptive it hits on the database so instead of getting the 000 descriptive it is getting the 000.15 etc etc.

I am grouping on my formula as I need to do a count as well. Any ideas how I get the correct descriptive to show?

 

[SkipVought]

Hi,

Crystal Reports? Forum149.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[scott1971]

Thanks Skip, that's what I get for not checking which forum I was on! I hadn't even noticed that I'd posted that to the wrong one......bad ending to a bad day!