Chapter 4. Using Built-In Functions

IN THIS CHAPTER

What Are Functions? 37

Converting Data Types 38

Working with Date Functions 42

Using Mathematical Functions 48

Using Financial Functions 50

Manipulating Text Strings 52

Formatting Values 55

Domain Aggregate Functions 59

Using the Is Functions 61

Interaction 61

Case Study: Add Work Days 64

What Are Functions?

Built-in functions are commands provided by Access and VBA that return a value. The value returned is dependent on the purpose of the function and the arguments, if any, passed to it. VBA is rich in functions that perform a variety of tasks and calculations for you. There are functions to convert data types, perform calculations on dates, perform simple to complex mathematics, make financial ...

Get Microsoft® Office Access 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial