Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help on adding multiple row values into one value

Status
Not open for further replies.
toblerone65

toblerone65

MIS
Apr 18, 2007
209
US
Hello everyone, need some help to build a logic formula.

I have 3 groups and sample data as below
GH1 CA
GH2 Santa Barbara
GH3 94015
Det 10 S RA
20 A PA
30 S JA

where ever I have Value as S in second column, i need to sum up those values separated by / and show data like below


10 S RA/JA
20 A PA
30 S RA/JA



Any help will be greatly appreciated.

 
Status
Not open for further replies.

Similar threads

CrystalUser90
  • Locked
  • Question
Same field on two tables, merge into one field on report 1
Replies
2
Views
355
CrystalUser90
CrystalUser90
semsel
  • Locked
  • Question
Checking if a value exists in an Array for conditional suppression
Replies
0
Views
434
semsel
semsel
lm1340
  • Locked
  • Question
How to only get records that have data in at least one of many tables 1
Replies
2
Views
371
lm1340
lm1340
PDAnalyst
  • Locked
  • Question
Placing different data fields into the same location at the Details section
Replies
4
Views
114
PDAnalyst
PDAnalyst
ALC3
  • Locked
  • Question
Crystal Reports - adding table messes up summarized field.
Replies
2
Views
73
ALC3
ALC3

Part and Inventory Search

Sponsor

Back
Top