Report design - crosstab?

[Darrylles]

Hi all,

Can someone pls give me some pointers?.......

Some may say that the relationships / table designs are
incorrect, but I've cut the tables and relationships down to simplify it here.
Field names are also changed (the app. is a model of a certain project evaluation methodology - which I didn't really want to have to explain).

Proj records will have x number of Cost records dependant on length of project.

Relationship: tblProj.pk ->> tblCost.proj_fk
[tt]
tables:

tblProj tblCost
pk pk
proj proj_fk
cost1
cost2
cost3
Month
Year

I want to display records on both from and Report like this:

Proj
Mth/Yr Mth/Yr Mth/Yr Mth/Yr Mth/Yr Mth/Yr
Cost1 0 0 0 0 0 0
Cost2 0 0 0 0 0 0
Cost3 0 0 0 0 0 0
[/tt]
All col / row headings are data fields from the above tables, except for the Cost1/2/3 row titles.

So, there will be multiple Projects, each with 3 costs for every mth/Year that the Project runs. To make it simpler, we can assume that each project starts and ends at the same time, but Month and Year ARE data.

Any help much appreciated,

Regards,

Darrylle


"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk