SQL for Microsoft Access, 2nd Edition

Chapter 6Creating Calculated Fields

Introduction

In this chapter, you will learn how to implement calculated fields in your queries. You will become familiar with the arithmetic operators, the aggregate functions, the string functions, and the date and time functions. You will also find a reference for additional functions used in Microsoft Access’s SQL view.

Keywords

ABS ()

AVG ( )

CCUR ()

COUNT (*)

COUNT (ColumnName)

DATE ()

DATEPART (interval, date [firstweekday] [, firstweek])

DAY ()

FIRST ()

FORMAT (ColumnName, DateFormat)

HOUR ()

INSTR (Start, SourceString, SearchString)

INT ()

LAST ()

LCASE ()

LEFT (StringExpression, n)

LEN ()

LTRIM ()

MAX ()

MID (StringExpression, Start, Length)

MIN ()

MINUTE ()

MONTH ()

NOW ...