How to Query the Last Row in a Series in Microsoft Access
How can I get the last order for each of my customers? Or, how do I get the current status of each of my cases? If you’ve ever asked a question like that while working on your Access databases, this video is for you. This week we return to our Microsoft Access playlist to learn how to get the last, or current row for a categorical variable (column value) in an Access query. Knowing how to do this simple query can save you a lot of time over the alternatives.
Supporting a Microsoft Access database and need help? Call me today.