Performing Calculations and Using Functions
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.
KeywordsDecimal Point Aggregate Function Generic Casting Access Version ANSI Standard
Unable to display preview. Download preview PDF.