Count but not the repeated ones

[aattas]

Experts,
I think this is a very simple question but nothing works for me.

How can i tell the report not to count repeated numbers?

I did declare to hide the duplicates and still it is counting.

I tried to defined a specific field =str(Count(ref)) but still it is counting as if it is still there.

Thanks

[June7]

Build a query that aggregates data so values are not duplicated and use that as report recordsource. Provide sample of data or attach database.

[isladogs]

Hiding the duplicates just stops them being displayed but they are still there.
As June said, create your report using a query with no dupes e.g. Try SELECT DISTINCT

[arnelgp]

this will work on Print Preview only:

Dim dict As Object
dim lngCount As Long

Private Sub Report_Open(Cancel As Integer)
    Set dict = CreateObject("scripting.dictionary")
End Sub

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If dict.Exists([TextboxNameToCount] & "") = False Then
        lngCount = lngCount + 1
        dict.Add [TextboxNameToCount] & "", [TextboxNameToCount]
    End If
    Me.TextboxToDisplayCount = lngCount
End Sub

[theDBguy]

Hi. You might also be able to use Grouping in your report to do the counting. Just a thought...