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..
In all the 4 previous posts on operators, you have seen some specific operators that can be used to perform certain specific actions. In addition to this, there are still a few additional operators provided by MS Access to assist you in your data analysis.
In this post, you’ll learn about these additional operators….
Today, you’ll learn to use two very useful concatenation operators in MS Access. By definition, ‘Concatenation’ means linking of two things as in a series or chain. From MS Access standpoint, concatenation means joining/linking two strings together.
So, let’s see how you can use these operators to your benefit….
In simple words, you would be interested, at times, in knowing the output when one expression is true and(/or) second expression is also true. You can think of Boolean logic as a simple way of comparing individual inputs and expressions. In order to make those comparisons, it uses what are called as operators aka “Logical Operators”. Note that Boolean logic is a form of logic that reduces all values to either TRUE or FALSE.
In this post, you are going to learn about Logical Operators in MS Access. You will make use of logical operators to combine two expressions and return a value of “TRUE”, “FALSE”, or “NULL” depending on the Boolean value of the expression on which logical operation is being done.
In this post you’ll learn how and when to use the comparison Operator. As the name suggests, comparison operator allows you to perform comparison between two operands.
As discussed in the earlier post ‘Applying Criteria in MS Access’, you will now be using and analyzing in details the various operators that are available in MS Access. In this post you will learn the basics of arithmetic operator.