Software

Ask something
Discussion Locked

MS Access Report

0 helpful
1 reply

by raaghavan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by tony hopkinson

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

This discussion is closed to new replies.