Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Counting an NthMostFrequent Field

Status
Not open for further replies.

StephenSB

Technical User
Nov 8, 2001
7
GB
Is it possible to count the number of occurrences of the most frequent field? I have a product description which I have the most frequent description for, but I also need to know how many times the description has been found. I have tried to do a conditional count but get an answer of 0 every time. Is there any way this can be done?
 
I think the problem is that the most frequent field is not known until other processing has been done. You could try counting the occurance of each distinct field Madawc Williams
East Anglia
Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top