Problem using 'Distinct Count' in formula

[Sinead]

I am in the add formula section of Crystal Reports.
I have the following statement in Crystal syntax

Distinct Count ({Users.TelephoneNumberID}, {Zone.Name})
The error says that the remaining text does not appear to be part of the formula.

If I use the query
Count ({Users.TelephoneNumberID}, {Zone.Name})
it works fine.
How can I get it to select distinct records

 

[mmaz]

Do you have a space between "Distinct" and "Count"? If you do, delete it and it should work.

 

[Sinead]

That worked. Thanks a million for your help.

In George Pecks book 'Crystal Reports, The complete Reference', it says that Distinct and Count are two separate words.

 

[dgillz]

Sinead-

When writing your formula in crystal reports, all recognized words in crystal syntax will show as blue text. If you misspell a word or put a space where it doesn't belong, crystal will show it as black text and you know you have an error. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office