1
111
I have a total query with a date field which is giving me problems.
What i need the date field to return is a month and a year ie: "9,2003" ;
"1,2004" etc.
what i'm getting from this is "9,2" : "10, "
The expression i'm using is:
year: DatePart("m",[Date]) & ", " & DatePart("yyyy",[Date])
Can someone show me what I"m doing wrong???
Thanks
What i need the date field to return is a month and a year ie: "9,2003" ;
"1,2004" etc.
what i'm getting from this is "9,2" : "10, "
The expression i'm using is:
year: DatePart("m",[Date]) & ", " & DatePart("yyyy",[Date])
Can someone show me what I"m doing wrong???
Thanks