Buddy & Gunnar, Thanks for your replies. Is there a way I can get the answer into a variable, as I then want to use this to decide how to order some printing which prints totals for identical values, if there are any, or prints them as they have been entered into a pricing schedule if there aren't any ? All I want to know is if there are any identical values or not in the data to be printed. I trust that this explains what I am trying to do a bit more clearly. (Perhaps I need the IF_UNIQUE function ?)
Thank you. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Tuesday, 18 March 2008 11:39 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Unique Values John You could do something like this SELECT COUNT(*) TxtColumn FROM TableName + GROUP BY TxtColumn HAVING COUNT(*) > 1 Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Docherty Sent: Tuesday, March 18, 2008 6:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Unique Values I was wondering if there is a quick way of determining if all rows in a selection have a distinct value, the column in question being a text field. Any suggestions (or the obvious answer which I cannot think of), would be much appreciated. Thank you. Regards, John Docherty --- RBASE-L =======================3D======================= D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D======================= D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D======================= D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D======================= D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D======================= D=
