Hi all,

I'm using Crystal Report 8.5 and having a problem here, any help would be much more appreciated. Please. !!

I have 2 tables link by MCCNo

TableA: Date WeightIn
1/3/2005 1000
4/3/2005 500

TableB: Date WeightOut
3/3/2005 600

How can I show them in order of date as well as calculate the weight ( weightIn - WeightOut)

Date Weight Total

1/3/2005 1000 1000
3/3/2005 600 400
4/3/2005 500 900
If I put them in detail section, record will be duplicated.

I'm struggling with this problem, please help !!

Thank you in advance ...thankssssssssssssssssssssssssssssssssss

Regards,
Utty