Horizontal Grouping by year? Help!

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top