Count unique using calculated control

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zilla" wrote in message
...
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