txtCountDistinct to reflect the Filter

  • Thread starter Thread starter bhammer
  • Start date Start date
B

bhammer

In the form footer I want txtCountDistinctAddresses to count the number of
unique addresses in the set of records even after the user applies a filter
(as opposed to in the recrodset of the ControlSource query).
 
Just for clarification, you want to have a count distinct for all of distinct
records, regardless of the filter. So if there are five distinct items, you
want txtCountDistinctAddress to read five even if the filter limits that
number to, say, two?
 
Sorry, other way around--say there are 100 records, with 75 different
addresses listed. The textbox should display "75". Then the user filters for,
say, a date, resulting in 50 records with 40 different addresses. The textbox
should then display "40". Then if the filter is removed it should bo back to
"75".
 
Back
Top