[Brian62]

I am creating a report that needs to show the beginning and ending dates to show up on the report.

Example: The report shows dates between 1/01/08 through 11/12/09 (multiple records)

The report heading would need to show: Annual Report Jan 2008 thru Oct 2009

Is there a way that I can use the dates on the report from a query to give me what I need?

[The Villan]

Brian
It is important you tell us what application you are using and the version.

[Brian62]

Sorry, it's Access 2007.

[OBP]

Brian, yes you can with a bit of manipulation in the query.
You will need to create 2 new Column with the following headings
Start: format([Start Date], "mmm yyyy")
Finish: format([Finish Date], "mmm yyyy")

Where Start and Finish Dates are your start and finish dates, if they originate on a form you will have to include the form name like this format(forms![FormName]![Start Date], "mmm yyyy")

[Brian62]

Worked perfectly. Thanks!