Grouping dates in report

[Troogroove]

I have created a report to return information based on the begin and end dates entered and it returns the data.

The problem is that it returns 3 or 4 entries for a month where as i just want one entry for the month. I have a sum calculation in the query to total the total cost.

I have set up Sorting and grouping in the report but it seams to have no effect on the results.

=DatePart("m",[Start Date])

Thats my criteria and im searching from the start of a month to the end.

Thanks for looking

 

[stopher]

Where are you using the =DatePart("m",[Start Date]) expression?

I would create a new field in underlying query based on this expression e.g.
ReportMonth: DatePart("m",[Start Date])

Then you can group by Report month in your query or, if you need the detail, do the grouping in the report on ReportMonth.

hth
Stopher