Display month not month number in report?

  • Thread starter Thread starter david.isaacks
  • Start date Start date
D

david.isaacks

SELECT [Facility VISN], MoNo, Count(*) AS Ct
FROM [SELECT 3 AS MoNo, [Facility VISN] FROM Output_MAR_2006
UNION ALL
SELECT 2 AS MoNo, [Facility VISN] FROM Output_FEB_2006
]. AS X
GROUP BY [Facility VISN], MoNo
ORDER BY [Facility VISN], MoNo;

This my query for my report. However I want to display the month name
and not the month number. So Fedraury instead of 2.

David
 
Use a text box in your report:

Control Source: =DateSerial(2000,[MoNo],1)
Format: mmmm
 
In Access 2000 or later, you should be able to set the Control Source of
your text box to:
=MonthName([MoNo])

Be sure to change the Name of the text box as well: Access gets confused if
the control has the same Name as a field but is bound to something else.
 
Back
Top