General discussion

  • Creator
    Topic
  • #2138160

    MS Access Report

    Locked

    by raaghavan ·

    Hi all,

    I have prepared a database in MS access-2007 to enter the day-to-day expenses in the office. One of the columns is Status Expenses for which the data will be either “R” or “NR”. Here “R” means Recoverable and “NR” means non-recoverable.

    Now While making the report, I am grouping the expenses under two headings “R” and “NR”. I want that in the report the group heading should show the full form of “R” and “NR” i.e. “R”- Recoverable and “NR”-Non Recoverable. Is it possible and if so how? Kindly help me.

    Regards
    Raaghavan

All Comments

  • Author
    Replies
    • #2437862

      SQL for it would be

      by tony hopkinson ·

      In reply to MS Access Report

      Select
      Case [Status Expenses]
      WHEN ‘R’ THEN ‘Recoverable’
      ELSE ‘Non-recoverable’
      END AS [Expense Status]
      From [SometableWithExpensesIntIt]

Viewing 0 reply threads