I have created a query for my database where some values are duplicates.
How would I create a query or filter so that the query only returns a row for each unique item. I have tried altering the Uniquerecords/Uniquevalues fields, but this doesn't work. The only way I can think to do it is through SQL but I am not conversant with this language. I have basic knowledge of MS Access.
My spreadsheet is as below:
ID: Agent: Chase Percent: Percent Paid:
20XV037 M 20 10
28XV058 P 20 19
28XV058 P 50 19
24CW021 P 20 15
I need the result to appear so that only the highest chase percent for each ID is shown
i.e. the table should show the row for 20XV037, and then the row for 28XV058 but only row with the 50% chase percent and then the row for 24CW021
Can anyone help?
How would I create a query or filter so that the query only returns a row for each unique item. I have tried altering the Uniquerecords/Uniquevalues fields, but this doesn't work. The only way I can think to do it is through SQL but I am not conversant with this language. I have basic knowledge of MS Access.
My spreadsheet is as below:
ID: Agent: Chase Percent: Percent Paid:
20XV037 M 20 10
28XV058 P 20 19
28XV058 P 50 19
24CW021 P 20 15
I need the result to appear so that only the highest chase percent for each ID is shown
i.e. the table should show the row for 20XV037, and then the row for 28XV058 but only row with the 50% chase percent and then the row for 24CW021
Can anyone help?