Solved Filter Data Max Value In column

[mard3010]

Good afternoon,

I have table that will be filtered but different combo-boxes / text-boxes. If it matches the it shows a sub-form as data sheet, resulting something something like this:

ID | Issue | Title
1 | 1 | A1
2 | 2 | A1
3 | 3 | A1
4 | 1 | B2
5 | 2 | B2
6 | 1 | C3


I want when someone clicks "show latest" it will show this:

ID | Issue | Title
3 | 3 | A1
5 | 2 | B2
6 | 1 | C3



Cheers

 

[MajP]

How to Select the First/Least/Max Row per Group in SQL

www.xaprb.com

SQL MAX() function with GROUP by, ORDER by - w3resource

SQL MAX() function with GROUP by, ORDER by: How the GROUP BY and ORDER BY clause along with the SQL MAX() can be used to find the maximum value of a column over each group.

www.w3resource.com

 

[mard3010]

Thanks MajP, will have a look at them.

 

[arnelgp]

 

[mard3010]

Thanks you both.

Managed to do it.