Hi all, Who can help me to make a SQL to do the following report?
the Joining Table make me confuse...
Cross-Tab Wizard can make One Table only, but I need make Old New Total Comparing... Report
Table Structure:
Persdata: [Identity], /Nature/, /District/, ....
Donation: [RecpNum], DonationDa, /Identity/, ... /Project1/, /Donation1/, /Project2/, /Donation2/, /Project3/, /Donation3/, /Currency/, ?LastDonDa
Exchange: [Currency, ExchDate], ExChRate
Project: [Project], ProjectNam, /PjGroup/
Nature: [Nature], Naturename...
District: [District], Districtname...
Primary Key is []
Link Key is //
i.e. Sum of Donation1, Donation2, Donation3 is total donation on that Currency....
Check the Exchange Table and Convert to HK$ for Calculation and report
Project1 must be empty but Project2, project3 may be empty...
1st Summary Report I have no idea to do:
Now, I need to make a report of sth like Cross-Tab Check...
# of donar on Period "PustartDate" to "PubEndDate
Individual (nature Value 1) Church (Value 2) Organisation (Value 3)
By District Old New Total Old New Total Old New Total
A0 (non-empty Last DonationDa as Old, empty for New)
A1
A2 36 4 40 ,....
...
2nd Summary Report... Project.group totally is 1 to 8, list them vs with District...
I want what user wants but I donno how to do....
Project may appear in project1 or project2 or project3 together with the different Currency Rate on Each Month....
Donation vs Project in Period .....
By District Project.Group1 Project.Group2 .....
A0
A1 $ 564.00
A2
i.e. the Simple sum can handling the internal group on Projects.....
So, I need to make a report to Check the Project which is paid at which District....
After this make a yearly (Periods) Report
Grouping Data together with make another cross-tab to make above report...
but as you see, 2 complex for me and I don't how to do it...
pls give me hints to handle, thx
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.