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. Related Videos: How to Use Union Queries in MS Access https://www.youtube.com/watch?v=LHWYq5NgxgI How to Split One Column Into Two in Access Using the Split Function https://www.youtube.com/watch?v=vQX0taPQLB0 How to Query the Last Row in a Series in Microsoft Access You are watching this video now! How to Format Dates in MS Access Queries, Forms, and VBA Code https://www.youtube.com/watch?v=TaohJxP0-MI How to Use Nz in Microsoft Access to Handle Null and Empty Values https://www.youtube.com/watch?v=CR3FmVoRFys How to Use Crosstab Queries in MS Access https://www.youtube.com/watch?v=XRLS-XJ79ns How to Use Functions in MS Access Queries https://www.youtube.com/watch?v=i9W1Abkg5cs Follow us on social media: https://www.facebook.com/mackenziedataanalytics/ https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering How to Query the Last Row in a Series in Microsoft Access MS Access Hacks Microsoft Access Tips microsoft access database Data manipulation in MS Access Sean Mackenzie