not counting multiple fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I'm trying to make a report where records from some query i made are shown.
at the end of the report i want to show the totals of the data shown in the
report.
In these totals I want to count the amount of different appearances of a
certain field. the problem is I don't want access to count every appearance
of the field, only appearances with different data. the 'count' property
counts all of the appearances...
can anyone help?
thank you
 
Hi.
You could try:
=Sum (Abs([YourVariable]="WhatYouAreLookingFor"))
Basically what this does it count all records where the record meet you
specification.
Hope this helps.
Fons
 
It won't help. Basicly, I'm trying to count how many distinct appearances of
a column were in the report. Is there a way doing that through the report
design?

Fons Ponsioen said:
Hi.
You could try:
=Sum (Abs([YourVariable]="WhatYouAreLookingFor"))
Basically what this does it count all records where the record meet you
specification.
Hope this helps.
Fons

dshemesh said:
Hello,
I'm trying to make a report where records from some query i made are shown.
at the end of the report i want to show the totals of the data shown in the
report.
In these totals I want to count the amount of different appearances of a
certain field. the problem is I don't want access to count every appearance
of the field, only appearances with different data. the 'count' property
counts all of the appearances...
can anyone help?
thank you
Click to expand...
Click to expand...
 
Create a group heading for [TheColumn] field. Add a text box in the group
heading:
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No
Add a text box to the Report Footer:
Control Source: = txtCount

--
Duane Hookom
MS Access MVP


dshemesh said:
It won't help. Basicly, I'm trying to count how many distinct appearances
of
a column were in the report. Is there a way doing that through the report
design?

Fons Ponsioen said:
Hi.
You could try:
=Sum (Abs([YourVariable]="WhatYouAreLookingFor"))
Basically what this does it count all records where the record meet you
specification.
Hope this helps.
Fons

dshemesh said:
Hello,
I'm trying to make a report where records from some query i made are
shown.
at the end of the report i want to show the totals of the data shown in
the
report.
In these totals I want to count the amount of different appearances of
a
certain field. the problem is I don't want access to count every
appearance
of the field, only appearances with different data. the 'count'
property
counts all of the appearances...
can anyone help?
thank you
Click to expand...
Click to expand...
Click to expand...
 
Great Duane!!!!!
thank you very very much!
works great....

Duane Hookom said:
Create a group heading for [TheColumn] field. Add a text box in the group
heading:
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No
Add a text box to the Report Footer:
Control Source: = txtCount

--
Duane Hookom
MS Access MVP


dshemesh said:
It won't help. Basicly, I'm trying to count how many distinct appearances
of
a column were in the report. Is there a way doing that through the report
design?

Fons Ponsioen said:
Hi.
You could try:
=Sum (Abs([YourVariable]="WhatYouAreLookingFor"))
Basically what this does it count all records where the record meet you
specification.
Hope this helps.
Fons

:

Hello,
I'm trying to make a report where records from some query i made are
shown.
at the end of the report i want to show the totals of the data shown in
the
report.
In these totals I want to count the amount of different appearances of
a
certain field. the problem is I don't want access to count every
appearance
of the field, only appearances with different data. the 'count'
property
counts all of the appearances...
can anyone help?
thank you
Click to expand...
Click to expand...
Click to expand...
 
Back
Top