Calendar search by Month

[Stafford]

I've got a Calendar form that works well enough when I need to run Report/Queries based on the StartDate and EndDate parameters in my query.

What I would really Like to do is run a Report/Query where the User simply Selects the Month and Year.

I've got my query to display my data in the Month format

Today's Date By Month: Format$([Defect Totals].[Date By Month],"mmmm yyyy")

Now I don't know how I can get the query to get Month and Year
info from the Calendar. Is this possible or should I take another approach?

 

[Fuga]

Not sure if I understand,

Can´t you use month() and year() functions?

Fuga.

 

[Stafford]

Not sure if I understand,

Can´t you use month() and year() functions?

Fuga.

Ummmmmmm.... Not sure I know what you mean either.

As it is the Form has a button which activates a Macro which in turn runs a query and finally a report.

The query has a few parameters, but the date format on my query is Formatted by Month and year (i.e. September 2002)

Here is a screenie of my Form


The Form has a StartDate and EndDate box which I am thinking is useless if I want to run the query based on Month values.

 

[Stafford]

Screenie didn't attach!