Don't want to count duplicates in Report

[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

 

[Duane Hookom]

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

 

[gumby]

Duane,

Thank you!

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

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 Hookom
MS Access MVP

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

 

[gumby]

Duane,

Thank you!


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


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 Hookom
MS Access MVP

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

 

[Duane Hookom]

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

Duane,

Thank you!

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

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 Hookom
MS Access MVP

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