URGENT HELP NEEDED

[EscapeUK]

Please help this is urgent

I posted a similar question earlier hopefully this is a bit easier to under stand.

I have am looking at a SQL DB I can identifiy the items i need on my report by a field called document number

the table looks something like this

Doc Num Account Value1 Value2
1111 VAT3 17.5 17.5
1111 VAT3 0.30 0.30
1111 XC11 100 100
1111 XC11 1.70 1.70

What I need to do is display the VAT by each of the values it relates to.. like this

Doc Num Account Value1 Value2
1111 XC11 100 17.5
1111 XC11 1.70 0.30

Any help would be great. Please keep the instructions simple
Thanks

 

[kenhamady]

how do you know which VAT3 goes with which xc11? Are those the only 2 accounts? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal