Format 1000 as 1K or 1,000

Sometimes you want to format a number for reports, for easier reading, or just plain simplification.

  • Formatting the number with a comma
    1. Switch to Layout or Design view of your form or report
    2. Select the field Object with numerical data
    3. In the property sheet, under Format>Format
    4. 0,000 for thousands 0,000,000 for millions

  • Formatting the number as ###k
    1. Switch to Layout or Design view of your form or report
    2. Select the field Object with numerical data
    3. In the property sheet, under Format>Format
    4. 0,\k

      or, for millions

      0,,\m

      Advertisements

Multiple Access JOINS

For every join greater than 1, the expression needs to be enclosed in parethesis.

SELECT field1, field2, field3...fieldN FROM
(
   (
     (
       Table1
       {LEFT/RIGHT/INNER} JOIN Table2)
     {LEFT/RIGHT/INNER} JOIN Table3)
   {LEFT/RIGHT/INNER} JOIN Table4)
 {LEFT/RIGHT/INNER} JOIN Table5