Thanks Mike for your reply.
That would give me the number of occurences by grouping. Unfortunately it's a little more than that. What we're trying to do is (within one statement) get conditional counts for ranges. For instance, one count if the field is from 0 - 9, another if 10 - 19, etc. without having to generate a grouping indicator in advance. Ultimately we are trying to create a report with columns meeting certain criteria.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement