Don't want to count duplicates in Report

  • Thread starter Thread starter gumby
  • Start date Start date
G

gumby

I need the duplicates my report, but I don't want to count them. I was
to have a =count([]) and then a =count where is does not count the
duplicates.

Not sure how to do the second one.

David
 
One method is to create a group header for the field you want a unique
count. Add a text box to the group header:
Name: txtCount
Control Source:=1
Running Sum: Over All
Visible: No

Then in the report footer, add a text box:
Control Source:=txtCount
 
Duane,

Thank you!

What is the reason for why in the second part it would not work in the
page header?

David

Duane said:
One method is to create a group header for the field you want a unique
count. Add a text box to the group header:
Name: txtCount
Control Source:=1
Running Sum: Over All
Visible: No

Then in the report footer, add a text box:
Control Source:=txtCount

--
Duane Hookom
MS Access MVP

gumby said:
I need the duplicates my report, but I don't want to count them. I was
to have a =count([]) and then a =count where is does not count the
duplicates.

Not sure how to do the second one.

David
Click to expand...
Click to expand...
 
Duane,

Thank you!


What is the reason for why in the second part it would not work in the
Report header?


David


Duane said:
One method is to create a group header for the field you want a unique
count. Add a text box to the group header:
Name: txtCount
Control Source:=1
Running Sum: Over All
Visible: No

Then in the report footer, add a text box:
Control Source:=txtCount

--
Duane Hookom
MS Access MVP

gumby said:
I need the duplicates my report, but I don't want to count them. I was
to have a =count([]) and then a =count where is does not count the
duplicates.

Not sure how to do the second one.

David
Click to expand...
Click to expand...
 
You could try it second control in the Page Header but I doubt it would
display a value that is calculated in group header events.

There is another solution that create a totals query similar to your
report's record source. Then do a count of the records in the totals query.
This could be displayed in your page header using DLookup() or DCount() or
something similar.

--
Duane Hookom
MS Access MVP

gumby said:
Duane,

Thank you!

What is the reason for why in the second part it would not work in the
page header?

David

Duane said:
One method is to create a group header for the field you want a unique
count. Add a text box to the group header:
Name: txtCount
Control Source:=1
Running Sum: Over All
Visible: No

Then in the report footer, add a text box:
Control Source:=txtCount

--
Duane Hookom
MS Access MVP

gumby said:
I need the duplicates my report, but I don't want to count them. I was
to have a =count([]) and then a =count where is does not count the
duplicates.

Not sure how to do the second one.

David
Click to expand...
Click to expand...
Click to expand...
 
Back
Top