I am trying to write a query to retrieve records that contain the latest (maximum) version number and action can’t be “Deletion”.
Sample table is listed below named as Mytable:
ID Version Action Name
1 1 Data1
2...
Hi,
I tried to write a query seems pretty simple, but it did not work properly. I have a text field in an Access table; its format combines letters with digits, something like this: SSID-1, SSID-12334. Each time when inserting record into this table, I need to judge the maximum digit in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.