Same Field, Different Formulas??

[MMichaels]

HELP!!

I have a report that I have created and am running into ONE problem. I have this field called "StopCode" (which contains many values). I have another field called "StopCodePos" which stands for what the position of the StopCode is.. as in 1 or 2. So, right now it looks like this:

Number StopCode1 StopCode2
1 6 0
1 0 15

I want there to ONLY be one "Number 1" with a StopCode1 of 6 and a StopCode2 of 15... with no zeros and on the same line horizontally. To look like this:

Number StopCode1 StopCode2
1 6 15

PLEASE HELP!!!

Thanks in advance!!!

~ Melissa ~

 

[bdreed35]

You could try Grouping on the "Number" field.
Suppress the Detail Section.
Now, this portion may or may not work, depends on your data.
Create a Maximum summary for StopCode1 and a Maximum summary for Stop Code2.
Display both of these summaries in your Group Header.

~Brian

 

[MMichaels]

Thank you soooooo much. It worked!

~ Melissa ~

 

[Ngolem]

Your post is a bit too specific.

Do you always want the minimum value of Stopcode1 and the maximum value of Stopcode2??

if so the solution tendered is fine...but I find this a bit simplistic

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!