Grouping many different dates

[MaliciousMike]

I have a query which has many sums and counts on things like "Company name", "region name" and "Development Name".

I'm using this query for a report to do lots of percentages with, but now i need to filter this also by a date period.

So the user choses "Alex Homes" as the company name and then "July 2006" as the reporting month, and i need all the sums and counts to stay the same and only count/sum the records in the chosen month.

I can't seem to think of a way to do this.

If you need more info then ask.

 

[Brianwarnock]

How does it fail when you apply criteria to the date?

Brian

 

[MaliciousMike]

well... my records have a date field which have a long date format. none of them are the same because each record is done at a different time. I basically need to generalise the dates so that all july dates group together, all may dates etc etc, so i can filter that field and all the sums and counts would be fine.

I either do it in the query, making my reports piss easy, or i just leave the query without the counts and sums etc, and do the maths in the report... but i honestly don't know how... because "=Count([Company Name])" doesn't actually count the freakin' company name!

 

[Brianwarnock]

Do you need to create a field as below and group on that?
mth: Format([fldYourDate],"mmm/yyyy")


Or am I missing the point?
Brian

 

[Brianwarnock]

My previous post asked 2 questions, a reply would have been nice.

Brian