Tag Archives: MS Access Filter

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:

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

Lets see how to solve this..

Continue reading

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’ – Select Top 'n' or Bottom 'n' records from a dataset in MS Access 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.

Select Top 'n' or Bottom 'n' records from a dataset in MS Access

So, lets get started with the actual scenarios……

Continue reading

Applying Criteria in MS Access

In this post and the ones following next, you are going to learn how to filter the data so as to get the exact information that you want. So, what exactly is filtering the data? – Filtering means separating out or pulling out the ‘required information’ from the base data. Note that you need to know beforehand “what exactly is required”. And in order to get “what is required”, you need to specify certain rules or conditions that must be met. Such rules or conditions are known as “Criteria” and there are different ways of specifying this criteria. Let us see how this is done…..

Applying Criteria

Continue reading