Troogroove
Registered User.
- Local time
- Today, 19:46
- Joined
- Dec 11, 2006
- Messages
- 10
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
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