how to substitute names for digits in a header?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a report header (created by Grouping) I have a number instead of the month
name. I want to replace the number with the corresponding month name. I have
tried using this statement in the Control Source line in Properties.
=IIf([Birth Month]=1,"January")
This works for 1 month but I can't seem to add the other 11 months to the
statement. I repeatedly get the error message "You have used a operator
without an operand" or "You have used a comma or quote or added a
parathensis"
This is the last item in a membership DB my club needs.
 
If you are using an actual date, then you can simply use the FORMAT command
to display only the Month name.

You can do this as the full month name, or the abbreviated month name.

Add an unbound text box and put something like the following in it...


=Format([SomeDateField],"MMM")



Hope that helps,

Rick B
 
Back
Top