HDTutorial
EN
How to Query the Last Row in a Series in Microsoft Access

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Query the Last Row in a Series in Microsoft Access

9,276 views July 25, 2020 6:53

Watch on YouTube
ChannelSean MacKenzie Data Analytics

Description from the creator

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
youtu.be/LHWYq5NgxgI
How to Split One Column Into Two in Access Using the Split Function
youtu.be/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
youtu.be/TaohJxP0-MI
How to Use Nz in Microsoft Access to Handle Null and Empty Values
youtu.be/CR3FmVoRFys
How to Use Crosstab Queries in MS Access
youtu.be/XRLS-XJ79ns
How to Use Functions in MS Access Queries
youtu.be/i9W1Abkg5cs

Follow us on social media:
facebook.com/mackenziedataanalytics/
twitter.com/seamacke
instagram.com/seamacke/
reddit.com/user/seamacke
linkedin.com/in/psmackenzie/

Thank you to my viewers!
Mention Promo Code SMDE25TWELVE for 25% off a twelve-month virtual machine subscription at:
beaverdamtechnologies.ca

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
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

About this tutorial

Sean MacKenzie Data Analytics published this 6:53 video tutorial on July 25, 2020. It has been watched 9,276 times on YouTube.

Duration
6:53
Published
July 25, 2020
Views
9,276
Likes
135

Tags

Share

Further reading

  • How to get last record in an access datatable social.msdn.microsoft.com

    Based upon the OPs description is doesn't appear to me as if the business he is working with will have a DBA or any technical staff so I can't recommend a server based solution in this instance. If any maintenance is re…

  • Find records with the most recent or oldest dates - Access support.microsoft.com

    A totals query is a select query that uses aggregate functions such as Min, Max, Sum, First, and Last to calculate values for a given field. The steps in this section assume that you run an event-management business — y…

  • MS Access: DLast Function techonthenet.com

    The Microsoft Access DLast function returns the last value from an Access table (or domain). Syntax. The syntax for the DLast function in MS Access is: DLast ( expression, domain, [criteria] Parameters or Arguments expr…

This tutorial in other languages