A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report



 
 
Thread Tools Display Modes
  #11  
Old May 2nd, 2010, 05:13 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Report

You should just tell us exactly what you have done and what your results
are.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Is it possible to send the entire database, so you can see how it is made.
I'm an amateur at Access, so it could væe much "strange" that makes this
not
work!

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news
The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results? If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3 of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

  #12  
Old May 6th, 2010, 02:47 PM posted to microsoft.public.access.reports
Per Erik
external usenet poster
 
Posts: 15
Default Report

I get an error message: "Multi-level GROUP BY clause is not allowed in a
subquery".

I have created everything according to your commandments, and the code in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news
The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results? If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3 of the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if there
are
33 participants, I would like it to be characterized by the eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

  #13  
Old May 7th, 2010, 05:18 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Report

Sounds like a issue with the record source of your report. I expect you used
a subquery to get the NR field. That's a no-no if you intend to sort by it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not allowed in a
subquery".

I have created everything according to your commandments, and the code in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news
The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results? If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3 of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

  #14  
Old May 7th, 2010, 10:48 AM posted to microsoft.public.access.reports
Per Erik
external usenet poster
 
Posts: 15
Default Report

Yes I have used a subquery called RANK (NR), and this will be sorted to
produce the correct results.
I get the error message when I put the txtCountAll to the Report Header
section.

"Duane Hookom" wrote:

Sounds like a issue with the record source of your report. I expect you used
a subquery to get the NR field. That's a no-no if you intend to sort by it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not allowed in a
subquery".

I have created everything according to your commandments, and the code in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results? If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3 of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

.

  #15  
Old May 9th, 2010, 05:51 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Report

You need to figure out a different method for the RANK. Is there a reason
why you can't use a running sum in the report to display the rank?

If you can't, you may need to post something about the report's record
source including significant SQL views.
--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Yes I have used a subquery called RANK (NR), and this will be sorted to
produce the correct results.
I get the error message when I put the txtCountAll to the Report Header
section.

"Duane Hookom" wrote:

Sounds like a issue with the record source of your report. I expect you
used
a subquery to get the NR field. That's a no-no if you intend to sort by
it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not allowed in
a
subquery".

I have created everything according to your commandments, and the code
in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results?
If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3
of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

.

  #16  
Old May 10th, 2010, 11:45 AM posted to microsoft.public.access.reports
Per Erik
external usenet poster
 
Posts: 15
Default Report

I'm using SQL RANK because I want a proper ranking.
Like this:
1. Person1 - 350 gr
* 2 Person2 - 340 gr
* 2 Person3 - 340 gr
4. Person4 - 320 gr

Those who have the same weight, should get the same space-digits. Like my
example above.

SQL statement in the query: SELECT A. GRAVITY, A. NAME, A. Club, A. CLASS,
(SELECT Count (*) FROM THE LORD AS B WHERE B. GRAVITY GRAVITY A.) +1 AS Rank
FROM THE LORD AS A;


"Duane Hookom" wrote:

You need to figure out a different method for the RANK. Is there a reason
why you can't use a running sum in the report to display the rank?

If you can't, you may need to post something about the report's record
source including significant SQL views.
--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Yes I have used a subquery called RANK (NR), and this will be sorted to
produce the correct results.
I get the error message when I put the txtCountAll to the Report Header
section.

"Duane Hookom" wrote:

Sounds like a issue with the record source of your report. I expect you
used
a subquery to get the NR field. That's a no-no if you intend to sort by
it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not allowed in
a
subquery".

I have created everything according to your commandments, and the code
in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results?
If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3
of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

.

.

  #17  
Old May 10th, 2010, 11:51 AM posted to microsoft.public.access.reports
Per Erik
external usenet poster
 
Posts: 15
Default Report

"Per Erik" wrote:

I'm using SQL RANK because I want a proper ranking.
Like this:
1. Person1 - 350 gr
* 2 Person2 - 340 gr
* 2 Person3 - 340 gr
4. Person4 - 320 gr

Those who have the same weight, should get the same space-digits. Like my
example above.

SQL statement in the query: SELECT A.VEKT, A.NAVN, A.KLUBB, A.KLASSE, (SELECT Count(*) FROM HERRER AS B WHERE B.VEKTA.VEKT)+1 AS Rank

FROM HERRER AS A;



"Duane Hookom" wrote:

You need to figure out a different method for the RANK. Is there a reason
why you can't use a running sum in the report to display the rank?

If you can't, you may need to post something about the report's record
source including significant SQL views.
--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Yes I have used a subquery called RANK (NR), and this will be sorted to
produce the correct results.
I get the error message when I put the txtCountAll to the Report Header
section.

"Duane Hookom" wrote:

Sounds like a issue with the record source of your report. I expect you
used
a subquery to get the NR field. That's a no-no if you intend to sort by
it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not allowed in
a
subquery".

I have created everything according to your commandments, and the code
in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results?
If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3
of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

.

.

  #18  
Old May 10th, 2010, 11:54 AM posted to microsoft.public.access.reports
Per Erik
external usenet poster
 
Posts: 15
Default Report

Sorry the SQL was wrong. I don´t know what happened!
The SQL statement in the query:
SELECT A.VEKT, A.NAVN, A.KLUBB, A.KLASSE, (SELECT Count(*) FROM HERRER AS B
WHERE B.VEKTA.VEKT)+1 AS Rank
FROM HERRER AS A;


"Per Erik" wrote:

I'm using SQL RANK because I want a proper ranking.
Like this:
1. Person1 - 350 gr
* 2 Person2 - 340 gr
* 2 Person3 - 340 gr
4. Person4 - 320 gr

Those who have the same weight, should get the same space-digits. Like my
example above.

SQL statement in the query: SELECT A. GRAVITY, A. NAME, A. Club, A. CLASS,
(SELECT Count (*) FROM THE LORD AS B WHERE B. GRAVITY GRAVITY A.) +1 AS Rank
FROM THE LORD AS A;


"Duane Hookom" wrote:

You need to figure out a different method for the RANK. Is there a reason
why you can't use a running sum in the report to display the rank?

If you can't, you may need to post something about the report's record
source including significant SQL views.
--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Yes I have used a subquery called RANK (NR), and this will be sorted to
produce the correct results.
I get the error message when I put the txtCountAll to the Report Header
section.

"Duane Hookom" wrote:

Sounds like a issue with the record source of your report. I expect you
used
a subquery to get the NR field. That's a no-no if you intend to sort by
it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not allowed in
a
subquery".

I have created everything according to your commandments, and the code
in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results?
If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3
of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

.

.

  #19  
Old May 10th, 2010, 04:04 PM posted to microsoft.public.access.reports
Per Erik
external usenet poster
 
Posts: 15
Default Report

I don´t know what "happened" with my SQL under here, but here is the correct:

SELECT A.VEKT, A.NAVN, A.KLUBB, A.KLASSE, (SELECT Count(*) FROM HERRER AS B
WHERE B.VEKTA.VEKT)+1 AS Rank
FROM HERRER AS A;


"Per Erik" wrote:

I'm using SQL RANK because I want a proper ranking.
Like this:
1. Person1 - 350 gr
* 2 Person2 - 340 gr
* 2 Person3 - 340 gr
4. Person4 - 320 gr

Those who have the same weight, should get the same space-digits. Like my
example above.

SQL statement in the query: SELECT A. GRAVITY, A. NAME, A. Club, A. CLASS,
(SELECT Count (*) FROM THE LORD AS B WHERE B. GRAVITY GRAVITY A.) +1 AS Rank
FROM THE LORD AS A;


"Duane Hookom" wrote:

You need to figure out a different method for the RANK. Is there a reason
why you can't use a running sum in the report to display the rank?

If you can't, you may need to post something about the report's record
source including significant SQL views.
--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Yes I have used a subquery called RANK (NR), and this will be sorted to
produce the correct results.
I get the error message when I put the txtCountAll to the Report Header
section.

"Duane Hookom" wrote:

Sounds like a issue with the record source of your report. I expect you
used
a subquery to get the NR field. That's a no-no if you intend to sort by
it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not allowed in
a
subquery".

I have created everything according to your commandments, and the code
in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your results?
If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every 1/3
of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

.

.

  #20  
Old May 11th, 2010, 04:42 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Report

I believe you can do this without the subquery but using a totals query and
a self join. MVP John Spencer has posted this type of ranking query in the
past. You will get a more efficient and functional result as needed in the
report record source.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I don´t know what "happened" with my SQL under here, but here is the
correct:

SELECT A.VEKT, A.NAVN, A.KLUBB, A.KLASSE, (SELECT Count(*) FROM HERRER AS
B
WHERE B.VEKTA.VEKT)+1 AS Rank
FROM HERRER AS A;


"Per Erik" wrote:

I'm using SQL RANK because I want a proper ranking.
Like this:
1. Person1 - 350 gr
* 2 Person2 - 340 gr
* 2 Person3 - 340 gr
4. Person4 - 320 gr

Those who have the same weight, should get the same space-digits. Like my
example above.

SQL statement in the query: SELECT A. GRAVITY, A. NAME, A. Club, A.
CLASS,
(SELECT Count (*) FROM THE LORD AS B WHERE B. GRAVITY GRAVITY A.) +1 AS
Rank
FROM THE LORD AS A;


"Duane Hookom" wrote:

You need to figure out a different method for the RANK. Is there a
reason
why you can't use a running sum in the report to display the rank?

If you can't, you may need to post something about the report's record
source including significant SQL views.
--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
Yes I have used a subquery called RANK (NR), and this will be sorted
to
produce the correct results.
I get the error message when I put the txtCountAll to the Report
Header
section.

"Duane Hookom" wrote:

Sounds like a issue with the record source of your report. I expect
you
used
a subquery to get the NR field. That's a no-no if you intend to sort
by
it.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I get an error message: "Multi-level GROUP BY clause is not
allowed in
a
subquery".

I have created everything according to your commandments, and the
code
in
the detail section is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3)
End Sub

Per Erik

"Duane Hookom" wrote:

Tell us how you have your report set up including the code that
is run
and
which section.

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
news The controls are visible in all the lines, not only in the 1/3.

"Duane Hookom" wrote:

It would help if you told us wasn't working. What are your
results?
If
the
controls are all visible, what do you see?

My suggestion show have displayed the control named Mark every
1/3
of
the
record count. I think you need to change the code to:


Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)
Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3
End Sub

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in
message
...
Like this:
NR. NAVN KLUBB VEKT
1 Jim Bekken Raufjøringen 9510 gr.
2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr.
3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr.
4 Jørgen Langerud Raufjøringen 5245 gr.
5 Ove Lauten Gjerdrum 4745 gr.
****
6 Per E. Hellerud Eidsvoll JFF 4625 gr.
7 Frank Hønsen Gjerdrum SFK 4525 gr.
8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr.
9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr.
10 Anders Wold Oslo Sportsfiske 3780 gr.
11 Tom Pedersen Gjøvik og Toten SFK 3325 gr.
12 Eric Olstad Toten JFF Lodd 2 3040 gr.
13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr.
14 Remi A. Olsen SFK Pimpel Sør 2540 gr.
15 Paal Runden Gjøvik og Toten SFK 2495 gr.

"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report.
So if
there
are
33 participants, I would like it to be characterized by the
eleventh.
Is
this
possible in a report?
Hope someone can help me with this!

.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.