modifying field in report?

[Susan]

For days of the week (not including Sunday) the field had numeric 1 or 2 or
3, etc. or combinations such as 13 for Monday and Wednesday. The database
had only 6 places for possible days a class could be held during the week.

For the report is there a way to:
1) Place a text line stating that 1=Monday, 2=Tuesday, etc.? I tried to
place * by the caption for the field and place the text in the Page Footer
but the = sign caused fits when I tried.
2) Test the field so that if there is a 1, Mon. would be written, etc.?
3) Do a query and generate the Mon, Tue, based on the numbers in the field
to generate output to use to produce the report?

Thanks for suggestions.

 

[KARL DEWEY]

Try using this but complete for all days --
IIf(InStr([x],"1")>0,"Monday") & IIf(InStr([x],"2")>0," Tuesday") &
IIf(InStr([x],"3")>0," Wednesday")

 

[KARL DEWEY]

PS - Add Trim function to remove leading space.

 

[Susan]

I am relatively new to Access. I have the field in the report and when I
try replace the "expression- is that the correct term" where the field name
was, I had to add an = at the beginning and then I received an error about
referring to itself. Do I somehow delete the label and field name and do
something else with the expression? The expression reminds me of JavaScript
and PHP so I do not feel totally confused I but do not know Access.

Thank you for your help.

 

[Susan]

Thanks for your help. The expression is working wonderfully now!

I had to change the Name property of the control before I used the
expression. So I encountered a very common source of the #Error -- using
the name of the control itself inside the expression that is the control
source!