Query Expression for Month Names

[tngirl]

I have been asked to create a report that will show data for each month of the year. The date field in the table that houses the data is called "Date". How would I write the expression in the query for the field name and criteria. If you help me with January, I can do the other months. Thanks so much for your help.

[June7]

Date is a reserved word. Should avoid reserved words as names.

Build an aggregate (GROUP BY) Totals query that summarizes by year and month. Or build a report using Grouping & Sorting functionality with summary calcs in footers.

Extract the year and month with expressions that create fields in query:

Format([Date], "yyyymmm")

Month([Date])

Year([Date])

Apply filter criteria to the constructed fields like any other field. Use the fields in aggregate query or in report to create grouping.