not counting multiple fields

D

dshemesh

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
 
F

Fons Ponsioen

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
 
D

dshemesh

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...
 
D

Duane Hookom

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...
 
D

dshemesh

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...
 
Top