A way to do this via the User tool could be to do a search on the table w/ no criteria, select all the rows, then Tools-->Reporting. Create a report with just the serial number. Sort and group upon Serial number. Then add a Statistic to Count serial number, computed on the serial number field.
Then you can look for anything with a count of 2 or higher. It's somewhat silly because in order to do that you'd have to visually scan the report, or export this to CSV and bring it into Excel or such and sort the count column. I am offering this alternative just in case you really don't want to do any SQL :-) Brien On Tue, Sep 16, 2008 at 8:33 AM, sucheta lakhe <[EMAIL PROTECTED]> wrote: > Can following query be done via user tool? > > I want to check if there are any two same serial numbers in the database. > Form name is asset and field name is serial # and database id = 536870917 > > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
