Horizontal Grouping by Year??

[niuginikiwi]

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

Block DateSown DatePlanted Block DateSown DatePlanted
44 30/10/04 11/12/04 44 30/10/05 11/12/05

45 6/11/04 18/12/04 45 6/11/05 18/12/05


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.

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.

 

[Al Campagna]

niuginikiwi,
Group your records on Year(SomeDate). In your example, use Page setup to create 2 (or
more) columns. Set Page Setup for Down then Across.
Give GroupYear a Header and Footer, and set the Footer Section ForceNewRow of Col to
After Section

Group Year Header...
[Year]
"Block DateSown DatePlanted"
Detail...
[Block] [DateSown] [DatePlanted]
YearFooter...
Set NewRow or Col to AfterSection = AfterSection

Will print as...

2004 2005
Block DateSown DatePlanted Block DateSown DatePlanted
44 30/10/04 11/12/04 44 30/10/05 11/12/05
45 6/11/04 18/12/04 45 6/11/05 18/12/05
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[niuginikiwi]

Thanks Al,
That worked out to what I was looking for.
Those who want a similar solution can refer to this...
Thanks
--
niuginikiwi
Nelson, New Zealand

niuginikiwi,
Group your records on Year(SomeDate). In your example, use Page setup to create 2 (or
more) columns. Set Page Setup for Down then Across.
Give GroupYear a Header and Footer, and set the Footer Section ForceNewRow of Col to
After Section

Group Year Header...
[Year]
"Block DateSown DatePlanted"
Detail...
[Block] [DateSown] [DatePlanted]
YearFooter...
Set NewRow or Col to AfterSection = AfterSection

Will print as...

2004 2005
Block DateSown DatePlanted Block DateSown DatePlanted
44 30/10/04 11/12/04 44 30/10/05 11/12/05
45 6/11/04 18/12/04 45 6/11/05 18/12/05
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."