G
Guest
Hi
I have a query that I want to be grouped, by month order, on my report. I
derived the month 'number' of all my records by using .......... Month:
DatePart("m",[Date]) .......... in the query and I now want the number to be
replaced by the NAME of the month in the report.
I tried this DLookUp formula
=DLookUp("[MonthName]","MonthsoftheYear","MonthID = '" & [Month] & "'")
as I have created a table with the MonthID [or #] and the MonthName, though
the control comes back with a ......... #Error
Can anyone point me in the right direction? TIA
I have a query that I want to be grouped, by month order, on my report. I
derived the month 'number' of all my records by using .......... Month:
DatePart("m",[Date]) .......... in the query and I now want the number to be
replaced by the NAME of the month in the report.
I tried this DLookUp formula
=DLookUp("[MonthName]","MonthsoftheYear","MonthID = '" & [Month] & "'")
as I have created a table with the MonthID [or #] and the MonthName, though
the control comes back with a ......... #Error
Can anyone point me in the right direction? TIA