>I have a table named planning in which I query a set of records into a cursor. Each record has whats known as a mainkey. There can be more than one record with the same mainkey. I would like to count the number of mainkeys in the table. For example, here is my query:L
>
>
>SELECT planning.mainkey, planning.planextra1, planning.ok, planning.okdate ;
>FROM planning ;
>WHERE planning.ok<>.t. ;
>INTO CURSOR crsresult
>
>
>A typical list of record would be:
>
>MAINKEY TYPE DATE
>JT001 Trouser 19/11/04
>JT002 Skirt 20/11/04
>JT001 Trouser 21/11/04
>
>Therefore I would like to count the number of different mainkeys. In this example the result would be 2. As there is only JT001 & JT002.
>
>Any help would be greatly appreciated.
Hi Neil
try
SELECT sum(1),mainkey FROM planning where planning.ok <> .t. GROUP BY mainkey
Actually that not what you want is it ? (Says nick editing his reply)
Nick Mason