modifying field in report?

  • Thread starter Thread starter Susan
  • Start date Start date
S

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.
 
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")
 
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.
 
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!
 
Back
Top