P
Pedro
I have been asked to do a report on our planting records.
The report involves 6 tables...
Here are the tables:
tblCrops, tblVarieties, tblSowing tblSowingDetails, tblPlantingDetails
and tblPlanting
Here are their relationships:
tblCrops 1:M tblVarieties 1:M tblSowingDetails M:1 tblSowing
tblSowingDetails 1:M tblPlantingDetails M:1 tblPlanting
I want to do a report that is grouped by year based on the DatePlanted
field in tblPlantingDetails horizontally. I want a report that looks
something like this:
2004
2005 2006
Block DateSown DatePlanted Block DateSown DatePlanted Block
DateSown DatePlanted
44 30/10/04 11/12/04 44 30/10/05
11/12/05 44 30/10/06 11/12/06
45 6/11/04 18/12/04 45 6/11/05
18/12/05 45 6/11/06 18/12/06
Block field comes from tblSowing, DateSown comes from tblSowingDetails
and DatePlanted is from tblPlantingDetails.
Can someone point out to me how and what I can do to achieve a report
in that format of presentation.
Thanks in advance for any help I may get.
The report involves 6 tables...
Here are the tables:
tblCrops, tblVarieties, tblSowing tblSowingDetails, tblPlantingDetails
and tblPlanting
Here are their relationships:
tblCrops 1:M tblVarieties 1:M tblSowingDetails M:1 tblSowing
tblSowingDetails 1:M tblPlantingDetails M:1 tblPlanting
I want to do a report that is grouped by year based on the DatePlanted
field in tblPlantingDetails horizontally. I want a report that looks
something like this:
2004
2005 2006
Block DateSown DatePlanted Block DateSown DatePlanted Block
DateSown DatePlanted
44 30/10/04 11/12/04 44 30/10/05
11/12/05 44 30/10/06 11/12/06
45 6/11/04 18/12/04 45 6/11/05
18/12/05 45 6/11/06 18/12/06
Block field comes from tblSowing, DateSown comes from tblSowingDetails
and DatePlanted is from tblPlantingDetails.
Can someone point out to me how and what I can do to achieve a report
in that format of presentation.
Thanks in advance for any help I may get.