I am using this query<BR><BR>SELECT tbl_OC.OCID, tbl_OC.OCName FROM tbl_OC;<BR><BR>I would like to display only the 1st occurrence of OCName from the table. Help
The first occurance sorted by what? <BR><BR>Do you want every occurance of OCID and only the first occurance of OCName, or do you want only the first occurance of OCID and OCName??
Only the first occurence of OCName because OCID is the Autonumber and will not repeat itself.<BR><BR>Help