Display month not month number in report?

[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

 

[Duane Hookom]

Use a text box in your report:

Control Source: =DateSerial(2000,[MoNo],1)
Format: mmmm

 

[Allen Browne]

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.

 

[david.isaacks]

For both of these I just get the #Error.

David

 

[david.isaacks]

The fact was it was my Error. It works great both ways. I thank you
both.

David