General discussion

Locked

MS Access Report

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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

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]

Back to Software Forum
1 total post (Page 1 of 1)  

Software Forums