On Thu, 5 Nov 2009 12:32:00 -0700, "Grant Dayton"
wrote:

I want to have my report display a date format for example 11-05-09, i want
it to display as 2009-11 (YYYY-MM). Can this be done? I couldn't figure out
if I try and format this in the table or the report ot the query that
generates the report.

Thanks


If it's stored in your table as a Date/Time field, simply set the Format
property of the textbox on the Report to

"yyyy-mm"

You can use the Format() function in the query to convert the date to a text
string, but it's more efficient to simply set the format on the report itself.
--

John W. Vinson [MVP]