How can I use MAXROW to achieve this? I am struggling with the expression.
Scenario: I have 3 columns, Category, Code, and ServiceNumber. All these columns are in one table name called “Event”
I want the ServiceNumber finds the last entry increment by 1 based on Category + Code.
Example: User select [Category] + [Code] = last entry of [ServiceNumber]
Let’s say the user selected: Cat1 + Cod01 and I want the service number find me the last entry of the [ServiceNumber] based on Cat1 + Cod01.
In this case, let’s say Cat1 + Cod01 = 99. Since the 99 is the last entry in the record, I want the 99 + 1 as a new input so when the user click Save it will save the data as Cat1 + Cod01 = 100.
This basically let the user know that the new entry of Cat1 + Cod01 is 100th.
Can someone please come up with an expression for me to try? Thanks.