CONTACT US: 778-373-4422 | info@mackenziemackenzie.com


Photo by Pexels

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

09-July-2020
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.

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop