Problem with rename value in report

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

Having insoluble problem for me, exaple:
Have to make report which needing to show total count of marks by month. That's known, but have to instead of mark (1,2,3,4,5) (which I have in field), put words (A,B,C,D,E).
One month that can be like this:


Mark Total
___________
B 4
C 15
D 2


and simetimes:



Mark Total
____________

A 6
B 1
D 1

Can someone hel me, please.
 
One approach would be to use IIF() statements to convert from (1,2,3,4,5) to
(A,B,C,D,E) in the query underlying your report.

--
Good luck

Jeff Boyce
<Access MVP>

Having insoluble problem for me, exaple:
Have to make report which needing to show total count of marks by month.
That's known, but have to instead of mark (1,2,3,4,5) (which I have in
field), put words (A,B,C,D,E).
One month that can be like this:


Mark Total
___________
B 4
C 15
D 2


and simetimes:



Mark Total
____________

A 6
B 1
D 1

Can someone hel me, please.
 
Back
Top