ReaderQuery : How to extract the last activity done with the client ?

In this post, you’ll learn to solve a specific query raised by one of our reader. The query is as follows:

Lets see how to solve this..

Advertisements

How to Select Top ‘n’ or Bottom ‘n’ records from a dataset?

In this post, you will learn how to create a query to extract Top ‘n’ or Bottom ‘n’ records from a particular dataset. There are  instances when you’ll need to extract top or bottom ‘n’ records within a particular group.  In order to do so, MS Access provides a nifty feature  ‘Return’ – that is used to extract the required Top or Bottom values. This feature is available under the Query setup in the Design Tab of the ribbon.

So, lets get started with the actual scenarios……