wrong month displays in access report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nutmeg - 23 Dec 2005 20:16 GMT

I have a group heading on a report on a date field and have it set to group
by Month. I am using this expression in the control for the heading:
=DatePart("m",[dteExpediteRequestDate]) The format is set to "mmmm"

The report is based on a parameter query where the user enters a date range.
I currently only have 4 test records in the database, all dated in December.
(The date is auto-populated).

When I run the report and enter 12/1/05 start and 12/31/05 end, the month
displayed in my heading is January. Does anyone know how I can make it say
December?

Thanks.

Reply to this Message

Van T. Dinh - 23 Dec 2005 20:46 GMT

Just use:

[dteExpediteRequestDate]

and leave the Format Proerty at "mmm" or use:

Format([dteExpediteRequestDate], "mmm")

and don't worry about the Format Property.

See Microsoft Office article:

<http:/office.microsoft.com/en-us/HA011102181033.aspx>

for explanation on JET Date/Time.

Signature

HTH
Van T. Dinh
MVP (Access)

>I have a group heading on a report on a date field and have it set to group
> by Month. I am using this expression in the control for the heading:
[quoted text clipped - 12 lines]
>
> Thanks.

Reply to this Message

Nutmeg - 23 Dec 2005 20:51 GMT

So simple....thanks for your help!!

> Just use:
>
[quoted text clipped - 28 lines]
> >
> > Thanks.

Reply to this Message