Query date entry

[NightWalker]

I am trying to change this code so I do not have to enter a start date and an end date. I would like to enter just a month to receive the summary for the entire month. Here is the code I currently am using.

[NightWalker]

having troubles posting the code. every time I try to post my code it gives me a 503 error.

I am currently using CDate and a message box for "Enter Start Date" an another Message box for "Enter stop date"

I am trying to just enter a month number to get the summary for that whole month.

I have researched it and found Month() function but I could not get it to just replace The CDate function.

[NightWalker]

Here is my code. Is it possible to change it to select whole months using the month function or change it to be able to make it select an entire month by entering a number for a month.

[John_G]

First, avoid using "Date" as a field name or alias. "Date" is an MS Access reserved word and you run the risk of getting errors (and confusing anyone who reads your code....!)

Try a WHERE like this:

Where month(qry_343sTested_Step1.TestedDate) = [Enter month Number]

Note that this could give you erroneous results if your query contains data for more than one year.