Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How many unique records do I have?
Message
De
29/08/2000 16:02:32
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00408894
Message ID:
00410469
Vues:
14
You could run a query and group by ID, then do a recc().
I.e. sele * from TABLE group by ID into cursor temp

sele temp
? recc()

>I have a table with student ids. Some ids
>occur more than once. I'd like a count at the
>bottom of the report of UNIQUE ids, not just
>the number of records.
>
>Say there are 100 records, but only 86 unique ids.
>I'd like the '86' to show in my total field.
>
>Any suggestions? For now, I just ran another query
>and used a separate table with that one number to
>place it there. This seems sloppy.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform