Grouping problem in report

J

J Cole

I am relatively new to access and I am facing problem in generating a report
as requireed using the "Create report by using wizard" / even in editing the
report that gets generated.

I am reading in data from two tables and displaying the following
information:
<<Report in Design view looks like this>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
111 aaa 9.0
111 aaa 11.0
222 bbb 12.0
222 bbb 11.0
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

What I am actually looking for is a report in which I would be
able to display only the average race time for each driver and the average
time
for the track. As in, I'm looking for a report like below:
<<Desired report>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
222 bbb 11.5
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

Could some one guide me in the right direction to achive this?

Thanks in advance.
Cole
 
D

Duane Hookom

I would probably group by Track and then by Driver. Display the footer
section for each group. In each group footer, add a text box with a control
source of:
=Avg([Race Time])
Set the detail section Visible: No
 
J

J Cole

Thanks Duane, your suggestion was useful and it worked. However, I have now
run into another issue. The report that I am generating is 3 pages long and
interestingly the second page shows not data (the second page is left blank)
! Any thoughts on this one. Apologies, that I have not searched for similar
posting on this forum. I will lookup for the same.
If anyone has faced a similar problem and got over it, kindly let me know.

thanks,
cole

Duane Hookom said:
I would probably group by Track and then by Driver. Display the footer
section for each group. In each group footer, add a text box with a control
source of:
=Avg([Race Time])
Set the detail section Visible: No

--
Duane Hookom
MS Access MVP


J Cole said:
I am relatively new to access and I am facing problem in generating a
report
as requireed using the "Create report by using wizard" / even in editing
the
report that gets generated.

I am reading in data from two tables and displaying the following
information:
<<Report in Design view looks like this>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
111 aaa 9.0
111 aaa 11.0
222 bbb 12.0
222 bbb 11.0
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

What I am actually looking for is a report in which I would be
able to display only the average race time for each driver and the average
time
for the track. As in, I'm looking for a report like below:
<<Desired report>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
222 bbb 11.5
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

Could some one guide me in the right direction to achive this?

Thanks in advance.
Cole
 
D

Duane Hookom

I would make sure the margins + report width did not exceed the width of
your paper.

--
Duane Hookom
MS Access MVP
--

J Cole said:
Thanks Duane, your suggestion was useful and it worked. However, I have
now
run into another issue. The report that I am generating is 3 pages long
and
interestingly the second page shows not data (the second page is left
blank)
! Any thoughts on this one. Apologies, that I have not searched for
similar
posting on this forum. I will lookup for the same.
If anyone has faced a similar problem and got over it, kindly let me know.

thanks,
cole

Duane Hookom said:
I would probably group by Track and then by Driver. Display the footer
section for each group. In each group footer, add a text box with a
control
source of:
=Avg([Race Time])
Set the detail section Visible: No

--
Duane Hookom
MS Access MVP


J Cole said:
I am relatively new to access and I am facing problem in generating a
report
as requireed using the "Create report by using wizard" / even in
editing
the
report that gets generated.

I am reading in data from two tables and displaying the following
information:
<<Report in Design view looks like this>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
111 aaa 9.0
111 aaa 11.0
222 bbb 12.0
222 bbb 11.0
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

What I am actually looking for is a report in which I would be
able to display only the average race time for each driver and the
average
time
for the track. As in, I'm looking for a report like below:
<<Desired report>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
222 bbb 11.5
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

Could some one guide me in the right direction to achive this?

Thanks in advance.
Cole
 
J

J Cole

Thanks again! It worked.


Duane Hookom said:
I would make sure the margins + report width did not exceed the width of
your paper.

--
Duane Hookom
MS Access MVP
--

J Cole said:
Thanks Duane, your suggestion was useful and it worked. However, I have
now
run into another issue. The report that I am generating is 3 pages long
and
interestingly the second page shows not data (the second page is left
blank)
! Any thoughts on this one. Apologies, that I have not searched for
similar
posting on this forum. I will lookup for the same.
If anyone has faced a similar problem and got over it, kindly let me know.

thanks,
cole

Duane Hookom said:
I would probably group by Track and then by Driver. Display the footer
section for each group. In each group footer, add a text box with a
control
source of:
=Avg([Race Time])
Set the detail section Visible: No

--
Duane Hookom
MS Access MVP


I am relatively new to access and I am facing problem in generating a
report
as requireed using the "Create report by using wizard" / even in
editing
the
report that gets generated.

I am reading in data from two tables and displaying the following
information:
<<Report in Design view looks like this>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
111 aaa 9.0
111 aaa 11.0
222 bbb 12.0
222 bbb 11.0
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

What I am actually looking for is a report in which I would be
able to display only the average race time for each driver and the
average
time
for the track. As in, I'm looking for a report like below:
<<Desired report>>

<Page Header>
----------------------------------------------------------------------
<Track Header>
TRACK NAME: Track 1
DRIVER CLASS NO. NAME RACE TIME
-----------------------------------------------------------------------
111 aaa 10.0
222 bbb 11.5
333 ccc 11.0
------------------------------------------------------------------------
<Track Footer>
Average time for track 1 = [ 10.67 ]
------------------------------------------------------------------------
<Page Footer>

Could some one guide me in the right direction to achive this?

Thanks in advance.
Cole
 

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