Date Display on Report

S

SarahJ

I have read the many date display threads on this site but have a new
question (at least I think it is new).

I am running a report from a parameter query and am able to get the dates to
display just fine, but I want to just get the month to display. I don't want
the acutal dates from the parameter. I want it to display the Name of the
month based on the dates from the parameter. Is there a way to do this?
 
J

John Spencer

Format ([The Parameter],"mmmm")

If the parameter is a reference to a form control

Format([Forms]![The Form Name]![The control Name], "mmmm")

Or if the control on the report has the parameter as its source then set the
controls format property to "mmmm"



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top