Count unique using calculated control

[Guest]

Hi,

I have a form the point of which is to show aggregated data, based on a
query. I need a calculated control on this form to cuont the unique values in
one particular field. this is proving rather more comlpicated than one would
expect.

The standard response to this problem is not to use a calculated control at
all, but to create a seperate totals query and then add that to the form
source query. I cannot seem to get this to work as the totals query itself
displays the count correctly but when added to the larger query the totals
get mangled.

Can anyone can help me either in finding a control source formula (ideally),
or a way of integrating a totals query effectively?

Thanks in advance

 

[Allen Browne]

The DCount() function in Access does not handle counting distinct values,
but there's a replacement here that does:
http://allenbrowne.com/ser-66.html