Click here to Skip to main content
15,908,674 members

Comments by Ghayyas Awan Mahtaab (Top 12 by date)

Ghayyas Awan Mahtaab 25-Sep-19 6:39am View    
@Maciej Los
Thanx Dude. It works for me. hatts off to you.
Ghayyas Awan Mahtaab 25-Sep-19 4:27am View    
Thanx Dude. Can I Get Solution from You?
Ghayyas Awan Mahtaab 25-Sep-19 3:59am View    
I cant Adjust Spaces in Data. Sorry i am new to Forum.
Ghayyas Awan Mahtaab 25-Sep-19 3:53am View    
Table Account
Partyid Title
225 Mushtaq
2211 Akram


Table Arrival Master
ArrivalID Adate RefDate PartyID
1 24-Sep 24-Sep 225
2 25-Sep 25-Sept 2211

Table Arrival Details
ArrivalID ItemID ItemQty ItemAMount
1 1 10 500
1 11 25 230
2 10 45 70
2 25 1 90
2 1 5 25


Table ReturnMaster

ReturnID REtDate RefDate PartyID
r1 24-Sep 24-Sep 225
R2 25-Sep 25-Sep 2211


Table ReturnDetails
ReturnID ItemID ItemQty ItemAMount
1 50 10 250
1 51 20 350
2 50 9 70
2 51 8 60



I want to get Summary of Single Date For Example 24-Sep Summary. Data Should Be Like This

ArrivalDate ArrivalRefDate ArrivalID PartyTitle ArrivalAmount ReturnAmount
24-Sep 24-Sep 1 225 730 600


Keep in mind that return data should be linked with arrival RefDate and Arrival PArty Title or ParyID.

data of a party should not go to other Party's row based on Main date. Where Refdate and PArtyID is same in Arrivalmaster And returnMaster. that data should be in One Row.
Ghayyas Awan Mahtaab 9-Jul-18 14:04pm View    
Ok...I'll do it in the morning...
I'll post results tomorrow...
Thanx to all for being with me...and giving valueable time to me...