Complex formula in ControlSource

[bhammer]

A2003
I want a calculated field to count number of unique Addresses (don't count
duplicates). In Excel I have a complex formula that works:

=Sum(IIf(FREQUENCY(IIf(Len([Address])>0,MATCH([Address],[Address],0),""),IIf(Len([Address])>0,MATCH([Address],[Address],0),""))>0,1))

Are there equivelent functions for Frequency and Match that can be used in
the ControlSourcr or from VBA?

-Brad

 

[bhammer]

Got it--almost. Grouping and sub-grouping is the answer, and there are many
posts on this. My problem now is that I cannot get the correct count in the
header.

I have an Issue Group and Address subGroup. The Address footer has
txtRunAddressCount
ControlSource =1
Running Sum Over Group

In the Issue footer another text box referring to the first
txtAddressCount
ControlSource =txtRunAddressCount

Now I want to show this in the Issue Header. So I try
another text box with
ControlSource =txtAddressCount

but it shows a count of 1 each time.

-Brad