Modifying a Query

[michelehaytko]

I'm far from being an Access expert, so forgive me if I don't make perfect sense. I have a database where questions and pages are entered on a daily basis. I have a table with three columns: data, pages, and questions. I have a query where I can sumarize the data by Month. (I created a query by using the wizard and I chose to summarize by Month). This returns all of the data, summarized by Month. I want to limit it further by year, so that it would return 12 months of data. I am at a loss! I've tried typing [Type Year] but I get no responses. I was able to create a limiting one where I type in the month and year [Type Month and Year] that works great, but it doesn't translate into the year only.

Thanks for any help you can lend!
Michele

 

[mhartman]

Hello:

In your query design, insert a new column, and add the following in the field section:

MyYear: Year([YourDateFieldHere])

This will extract just the year portion of your date. Then, enter the year for the criteria you want to query out.

This can work for month, and day as well
Regards
Mark

 

[michelehaytko]

Thanks! Works perfect!

 

[mhartman]

Your welcome and good luck with this!