Distinct for a single field

[#1]

Hey experts,

I have four fields in a table,1. chequeID 2. agreementID 3. LOSID 4. lesseID

what i want is :: unique values in chequeID , and not for the whole table.

i can use distinct for the whole table but not for a single field, can anybody guide me how to do for a single field ???

[johnw]

The answer is probably simple, but I have no idea what you're asking. Are you talking about script? Creating a table in script with unique values of chequeID? Showing unique values in a chart? Counting unique values? What are you after?

[#3]

Dear John,

One table with 4 fields, one of the field name is chequeID and tht should be unique, and not the whole table fields,

I dont want to use distinct for the whole table and when i use distinct for only chequeID it says 'invalid function'

Is their any other way to do this rather than doing it in charts / graphs,

Thanking your anticipation.

Regards,

Prashant A...

[tresesco]

As John was asking if you want this in script, is not clear even now.Still, assuming that you are expecting it so, try to load your data with like:

Load field1, field2,...... From.....Where Not Exists(ChequeID);

Regards, tresesco