Advertisement

Performing Calculations and Using Functions

  • Cristian Darie
  • Karli Watson
  • Chris Hart
  • Kevin Hoffman
  • Julian Skinner

Abstract

A number of times over the past few chapters you found that selecting data based on the simple column name didn’t meet your needs. Instead you needed to combine values or calculate new values based on the data in your database, such that the values you obtained in your results were ready for you to use. You have, for example, concatenated strings to create columns more suited to applications, and you’ve also performed simple calculations involving numerical data, such as multiplying the values of two columns together.

Keywords

Decimal Point Aggregate Function Generic Casting Access Version ANSI Standard 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Cristian Darie, Karli Watson with Chris Hart, Kevin Hoffman, Julian Skinner 2003

Authors and Affiliations

  • Cristian Darie
  • Karli Watson
  • Chris Hart
  • Kevin Hoffman
  • Julian Skinner

There are no affiliations available

Personalised recommendations