Please help me, really urgent.. ~"_"~
>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, thanks!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.