Hi, I need help to find the SQL on how to group this type of data.
I basically need to create a report that finds all duplicates in a table and print them out on a report. I have tried Groupby option but that will not show me all the dups it will only show me the 1 record that is a dup but I need to show that data.
I have another question that relates to the above query. I have an Amount field that I need to check for dups BUT... if the dups are a negative or positive same number amount, I need to treat them the same. I have tried the Abs conversion but it does not work in the SQL, it does not even come out in the results, ex. 182400 and -182400 these have to show up in the report as if were a match. Thanks for everyone that has helped so far!